Skip site navigation (1) Skip section navigation (2)

Re: Autovacuum & Table List Ordering

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Usama Dar <munir(dot)usama(at)gmail(dot)com>
Cc: pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Autovacuum & Table List Ordering
Date: 2008-01-03 14:39:26
Message-ID: 20080103143926.GD10950@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-hackers
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

In response to

Responses

pgsql-hackers by date

Next:From: Kevin GrittnerDate: 2008-01-03 15:15:59
Subject: Re: Slow count(*)
Previous:From: Alvaro HerreraDate: 2008-01-03 14:35:27
Subject: Re: Table rewrites vs. pending AFTER triggers

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group