Horton

Re: Fsync IO issue

Thomas Munro <thomas.munro@gmail.com>

View thread
From: Thomas Munro <thomas.munro@gmail.com>
To: ProfiVPS Support <support@profivps.hu>
Cc: Andres Freund <andres@anarazel.de>, pgsql-performance@lists.postgresql.org
Date: 2023-05-04T21:23:07Z
Lists: pgsql-performance 
On Fri, May 5, 2023 at 8:37 AM ProfiVPS Support <support@profivps.hu> wrote:
>  I feel like ANYTHING would be better than this. Even risking loosing _some_ of the latest data in case of a server crash (if it crashes we lose data anyways until restart, ofc we could have HA I know and we will when there'll be a need) .

Try synchronous_commit=off:

https://www.postgresql.org/docs/current/wal-async-commit.html