Added to TODO: * Improve the background writer
Allow the background writer to more efficiently write dirty buffers from the end of the LRU cache and use a clock sweep algorithm to write other dirty buffers to reduced checkpoint I/O --------------------------------------------------------------------------- Simon Riggs wrote: > On Wed, 2004-12-22 at 04:43, Tom Lane wrote: > > Bruce Momjian <pgman@candle.pha.pa.us> writes: > > > So what are we doing for 8.0? > > > > Well, it looks like RC2 has already crashed and burned --- I can't > > imagine that Marc will let us release without an RC3 given what was > > committed today, never mind the btree bug that Mark Wong seems to have > > found. So maybe we should just bite the bullet and do something real > > about this. > > > > I'm willing to code up a proposed patch for the two-track idea I > > suggested, and if anyone else has a favorite maybe they could write > > something too. But do we have the resources to test such patches and > > make a decision in the next few days? > > > > At the moment my inclination is to sit on what we have. I've not seen > > any indication that 8.0 is really worse than earlier releases; the most > > you could argue against it is that it's not as much better as we hoped. > > That's not grounds to muck around at the RC3 stage. > > Agreed, if somewhat reluctantly. > > We may have the time to test, but it is clear that we do not have the > time to validate those tests, then discuss and agree on the results. > > Time to go with what we have. > > [Mark's possible bug seems a higher priority for me.] > > -- > Best Regards, Simon Riggs > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match