Postgres Pro
Downloads
Home   >   mailing lists

Re: Fsync IO issue - Mailing list pgsql-performance

From Thomas Munro
Subject Re: Fsync IO issue
Date
Msg-id CA+hUKG+VBpWSyizQtDUk=WhP-DdvuZ1mbYk9ykksyRJ2OVxtVQ@mail.gmail.com
Whole thread Raw
In response to Re: Fsync IO issue  (ProfiVPS Support <support@profivps.hu>)
Responses Re: Fsync IO issue
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: ProfiVPS Support
Date:
Subject: Re: Fsync IO issue
Next
From: aditya desai
Date:
Subject: Connection drops on postgres 11.16