"Matthew T. O'Connor" <[EMAIL PROTECTED]> writes: > As of 7.2 we have lazy vacuum. The next logical step is setting up vacuum to > run automatically in the background either as some type of daemon or as > something kicked off by the postmaster.
> I am interested in working on this to do item, although I see it is assigned > to Tom right now. It's sufficiently far down my to-do list that I'm happy to let someone else do it ;-). > Second: There was some discussion > (http://archives.postgresql.org/pgsql-hackers/2002-05/msg00970.php) about > this not being neede once UNDO is on place, what is the current view on this? I do not think that is the case; and anyway we've pretty much rejected Vadim's notion of going to an Oracle-style UNDO buffer. I don't foresee VACUUM going away anytime soon --- what we need is to make it less obtrusive. 7.2 made some progress in that direction, but we need more. Launching VACUUMs on some automatic schedule, preferably using feedback about where space needs to be reclaimed, seems like a pretty straightforward small-matter-of-programming. The thing that would really be needed to make it unobtrusive is to find a way to run the vacuum processing at low priority, or at least when the system is not heavily loaded. I don't know a good way to do that. Nice'ing the vacuum process won't work because of priority-inversion problems. Making it suspend itself when load gets high might do; but how to detect that in a reasonably portable fashion? regards, tom lane ---------------------------(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
