Re: RC2 and open issues - Mailing list pgsql-hackers

From Zeugswetter Andreas DAZ SD
Subject Re: RC2 and open issues
Date
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA40184D27F@m0114.s-mxs.net
Whole thread Raw
In response to RC2 and open issues  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
> If we don't start where we left off, I am thinking if you do a lot of
> writes then do nothing, the next checkpoint would be huge because a lot
> of the LRU will be dirty because the bgwriter never got to it.

I think the problem is, that we don't see wether a "read hot"
page is also "write hot". We would want to write dirty "read hot" pages,
but not "write hot" pages. It does not make sense to write a "write hot"
page since it will be dirty again when the checkpoint comes.

Andreas


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: rc1 packaged ...
Next
From: Richard Huxton
Date:
Subject: Re: RC2 and open issues