Matthew T. O'Connor wrote: > Bruce Momjian wrote: > > >I have added an auto-vacuum TODO item: > > > >* Auto-vacuum > > o Move into the backend code > > o Scan the buffer cache to find free space or use background writer > > o Use free-space map information to guide refilling > > > > I'm not sure what you mean exactly by "Scan the buffer cache to find > free space or use background writer", the other two are definitely high > priority todo items (at least as far as autovacuum in concerned). >
I am thinking we could look for expired tuples when while they are in the buffer cache or before they are written to disk so we don't have to a sequential scan to find them. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (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 8: explain analyze is your friend
