Postgres Pro
Downloads
Home   >   mailing lists

Re: Autovacuum & Table List Ordering - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Autovacuum & Table List Ordering
Date
Msg-id 20080103143926.GD10950@alvh.no-ip.org
Whole thread Raw
In response to Autovacuum & Table List Ordering  ("Usama Dar" <munir.usama@gmail.com>)
Responses Re: Autovacuum & Table List Ordering  ("Usama Dar" <munir.usama@gmail.com>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Table rewrites vs. pending AFTER triggers
Next
From: Simon Riggs
Date:
Subject: Re: Dynamic Partitioning using Segment Visibility Maps