Re: synchronous_commit=off doesn't always return immediately - Mailing list pgsql-general

From tomrevam
Subject Re: synchronous_commit=off doesn't always return immediately
Date
Msg-id 24630130.post@talk.nabble.com
Whole thread Raw
List pgsql-general


Tom Lane-2 wrote:
>
>
> What sort of disk hardware have you got?  It sounds overstressed.
>
> It might help to increase wal_buffers.
>
>

The disk is a SATA drive and it will be replaced in future projects with a
better drive. However, I still don't understand why there is any halt in the
client when synchronous_commit is off.

Thanks,
Tomer
--
View this message in context:
http://www.nabble.com/synchronous_commit%3Doff-doesn%27t-always-return-immediately-tp24621119p24630130.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: Tim Uckun
Date:
Subject: A question about pg_standby.
Next
From:
Date:
Subject: Converting SQL to pg