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

From Greg Smith
Subject Re: synchronous_commit=off doesn't always return immediately
Date
Msg-id alpine.GSO.2.01.0907231215230.1656@westnet.com
Whole thread Raw
In response to synchronous_commit=off doesn't always return immediately  (tomrevam <tomer@fabrix.tv>)
Responses Re: synchronous_commit=off doesn't always return immediately
List pgsql-general
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.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

pgsql-general by date:

Previous
From: Andrew Klaassen
Date:
Subject: Re: table.column in query results?
Next
From: Bjørn T Johansen
Date:
Subject: Re: ERROR: could not access status of transaction 2495690984