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

Re: [HACKERS] More detail on settings for pgavd?

From: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
To: Shridhar Daithankar <shridhar_daithankar(at)myrealbox(dot)com>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>,pgsql-performance(at)postgresql(dot)org,PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [HACKERS] More detail on settings for pgavd?
Date: 2003-11-21 15:17:31
Message-ID: 3FBE2C8B.9040304@zeut.net (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-performance
Shridhar Daithankar wrote:

> Matthew T. O'Connor wrote:
>
>> But we track tuples because we can compare against the count given by 
>> the stats system.  I don't know of a way (other than looking at the 
>> FSM, or contrib/pgstattuple ) to see how many dead pages exist.
>
> I think making pg_autovacuum dependent of pgstattuple is very good idea. 

Only if pgstattuple can become much cheaper than it is now.  Based on 
the testing I did when I wrote pg_autovacuum, pgstattuple cost nearly 
the same amount as a regular vacuum.  Given that, what have we gained 
from that work?  Wouldn't it just be better to run a vacuum and actually 
reclaim space rather than running pgstattuple, and just look and see if 
there is free space to be reclaimed?

Perhaps we could use pgstattuple ocasionally to see if we are going a 
good job of keeping the amount of dead space to a reasonable level, but 
I'm still not really sure about this.

> Probably it might be a good idea to extend pgstattuple to return pages 
> that are excessively contaminated and clean them ASAP. Step by step 
> getting closer to daemonized vacuum.

I don't know of anyway to clean a particular set of pages.  This is 
something that has been talked about (partial vacuums and such), but I 
think Tom has raised several issues with it, I don't remember the 
details.  Right now the only tool we have to reclaim space is vacuum, a 
whole table at a time.



In response to

pgsql-performance by date

Next:From: Josh BerkusDate: 2003-11-21 17:09:00
Subject: Re: [HACKERS] More detail on settings for pgavd?
Previous:From: Shridhar DaithankarDate: 2003-11-21 15:06:54
Subject: Re: [HACKERS] More detail on settings for pgavd?

pgsql-hackers by date

Next:From: Carlos Guzmán ÁlvarezDate: 2003-11-21 15:22:51
Subject: Transaction Rollback problen (3.0 Protocol)
Previous:From: Tom LaneDate: 2003-11-21 15:10:26
Subject: Re: logical column position

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