Re: synchronous_commit=off doesn't always return immediately

From: Greg Smith <gsmith(at)gregsmith(dot)com>
To: tomrevam <tomer(at)fabrix(dot)tv>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: synchronous_commit=off doesn't always return immediately
Date: 2009-07-23 16:18:40
Message-ID: alpine.GSO.2.01.0907231215230.1656@westnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brian A. Seklecki 2009-07-23 16:29:20 Disable databse listing for non-superuser (\l) ?
Previous Message Andrew Klaassen 2009-07-23 15:51:39 Re: table.column in query results?