Re: synchronous_commit=off doesn't always return immediately

From: tomrevam <tomer(at)fabrix(dot)tv>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: synchronous_commit=off doesn't always return immediately
Date: 2009-07-24 03:53:41
Message-ID: 24630130.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-general by date

  From Date Subject
Next Message martin 2009-07-24 04:42:44 Converting SQL to pg
Previous Message Tim Uckun 2009-07-24 03:42:10 A question about pg_standby.