| From: | "Zeugswetter Andreas DAZ SD" <ZeugswetterA(at)spardat(dot)at> |
|---|---|
| To: | "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: RC2 and open issues |
| Date: | 2004-12-21 11:18:58 |
| Message-ID: | 46C15C39FEB2C44BA555E356FBCD6FA40184D27F@m0114.s-mxs.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2004-12-21 12:23:10 | Re: RC2 and open issues |
| Previous Message | Peter Eisentraut | 2004-12-21 11:17:48 | Re: rc1 packaged ... |