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
On Jan 3, 2008 7:39 PM, Alvaro Herrera [EMAIL PROTECTED] wrote:
Sure, feel free to propose a specific ordering. I think you would need
to take table size into account too.
Thanks, i thought we were already taking the database size into account
somewhat when we calculate the vacuum threshold
OK, so i was going through the autovacuum code and i noticed that when we
construct the table list to vacuum in a database per run, we don't process
them in a particular order. I mean since we pick the list up from pg_class
so it may be ordered on oid? but when we select a database we have a