Re: Bgwriter LRU cleaning: we've been going at this all wrong - Mailing list pgsql-hackers

From Greg Smith
Subject Re: Bgwriter LRU cleaning: we've been going at this all wrong
Date
Msg-id Pine.GSO.4.64.0706280852500.6275@westnet.com
Whole thread Raw
In response to Re: Bgwriter LRU cleaning: we've been going at this all wrong  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
Responses Re: Bgwriter LRU cleaning: we've been going at this all wrong
List 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@gregsmith.com http://www.gregsmith.com Baltimore, MD


pgsql-hackers by date:

Previous
From: Michael Enke
Date:
Subject: Re: self defined data type "with limit"?
Next
From: Tom Lane
Date:
Subject: Re: self defined data type "with limit"?