Re: [HACKERS] Autovacuum & Table List Ordering

2008-01-03 Thread Usama Dar
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

Re: [HACKERS] Autovacuum & Table List Ordering

2008-01-03 Thread Alvaro Herrera
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