Usama Dar escribió: > So wouldn't it make sense to pick up the tables in a similar order as well? > like sorting the list on (deadtuples - calculated threshold) this way we > will be vacuuming the tables in more need first.
Sure, feel free to propose a specific ordering. I think you would need to take table size into account too. Something that's also important to fix while you're doing that is fixing the "BUG" that is mentioned in the code that Simon griped about not long ago. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
