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 24712612.post@talk.nabble.com
Whole thread Raw
In response to Re: synchronous_commit=off doesn't always return immediately  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general


Alvaro Herrera-7 wrote:
>
> tomrevam wrote:
>
> This is why Tom was suggesting you to increase wal_buffers.  Did
> you try that?
>
>

Increasing the wal_buffers improved the performance. Is there a limit on how
big I can raise them? Is there anything that would work worse with bigger
wal_buffers?

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


pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Idle processes chewing up CPU?
Next
From: Jan-Erik
Date:
Subject: Re: split string by special characters