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 thresho
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
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
priori
