Re: Fsync IO issue

From: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
To: ProfiVPS Support <support(at)profivps(dot)hu>
Cc: Andres Freund <andres(at)anarazel(dot)de>, pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Fsync IO issue
Date: 2023-05-04 21:23:07
Message-ID: CA+hUKG+VBpWSyizQtDUk=WhP-DdvuZ1mbYk9ykksyRJ2OVxtVQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, May 5, 2023 at 8:37 AM ProfiVPS Support <support(at)profivps(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message aditya desai 2023-05-11 18:40:06 Connection drops on postgres 11.16
Previous Message ProfiVPS Support 2023-05-04 20:37:22 Re: Fsync IO issue