On Wed, 2002-10-16 at 05:22, Gavin Sherry wrote: > Hi all, > > I'm thinking that there is an improvement to vacuum which could be made > for 7.4. VACUUM FULLing large, heavily updated tables is a pain. There's > very little an application can do to minimise dead-tuples, particularly if > the table is randomly updated. Wouldn't it be beneficial if VACUUM could > have a parameter which specified how much of the table is vacuumed. That > is, you could specify: > > VACUUM FULL test 20 precent;
What about VACUUM FULL test WORK 5 SLEEP 50; meaning to VACUUM FULL the whole table, but to work in small chunks and relaese all locks and let others access the tables between these ? You could even fire up a separate thread to VACUUM [FULL] test WORK 5 SLEEP 50 CONTINUOUS; To keep vacuuming a heavily updated table. ------------------ Hannu ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html