Re: synchronous_commit=off doesn't always return immediately

Greg Smith-12 wrote:
>
> On Thu, 23 Jul 2009, tomrevam wrote:
>
>> bgwriter_delay = 20ms                   # 10-10000ms between rounds
>> bgwriter_lru_maxpages = 1000            # 0-1000 max buffers
>> written/round
>> bgwriter_lru_multiplier = 5.0           # 0-10.0 multipler on buffers
>> scanned/round
>
> These settings may be contributing to the problem.  You should never run
> the background writer that frequently--it just wastes resources and writes
> more than it should.  I'd suggest turning it off altogether
> (bgwriter_lru_maxpages = 0) and seeing if things improve any, just to rule
> that out as a potential source of issues.
>
>

The behavior of the system is the same with bg_writer_lru_maxpages = 0. Can
you
explain why transactions are sometimes synchronous even with the
synchrounous_commit
set to off?

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