Re: Bgwriter LRU cleaning: we've been going at this all wrong

From: Greg Smith <gsmith(at)gregsmith(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Bgwriter LRU cleaning: we've been going at this all wrong
Date: 2007-06-28 12:55:50
Message-ID: Pine.GSO.4.64.0706280852500.6275@westnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, 28 Jun 2007, ITAGAKI Takahiro wrote:

> Do you need to increase shared_buffers in such case?

If you have something going wild creating dirty buffers with a high usage
count faster than they are being written to disk, increasing the size of
the shared_buffers cache can just make the problem worse--now you have an
ever bigger pile of dirty mess to shovel at checkpoint time. The existing
background writers are particularly unsuited to helping out in this
situation, I think the new planned implementation will be much better.

--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2007-06-28 14:00:40 Re: AutoVacuum Behaviour Question
Previous Message Heikki Linnakangas 2007-06-28 12:01:56 Doc update for pg_start_backup