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-29 05:19:34
Message-ID: 24712612.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message mukeshp 2009-07-29 06:24:59 Monitoring tools for Postgresql
Previous Message Jan-Erik 2009-07-29 05:06:46 Re: split string by special characters