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

Re: Row level stats

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rod Taylor <rbt(at)rbt(dot)ca>
Cc: Neil Conway <neilc(at)samurai(dot)com>,PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Row level stats
Date: 2003-03-06 17:05:48
Message-ID: 16076.1046970348@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Rod Taylor <rbt(at)rbt(dot)ca> writes:
> On Thu, 2003-03-06 at 11:49, Tom Lane wrote:
>> The implementation I've had in mind for autovacuum would rely on FSM not
>> the pg_stats daemon.

> FSM as I understand it gets it information from vacuum, and has an space
> marker removed when an insert uses the tuple.

FSM doesn't, but easily could, keep track of the number of space
requests it gets.  We could also add some code to use it to keep count
of tuple deletions.  Unlike the pg_stats daemon, FSM doesn't necessarily
try to track every single table --- but it would track all the
heavily-used ones, which is plenty for AVD purposes.

I tend to think of pg_stats as a bit of a failed experiment.  The
overhead is excessive for what it accomplishes.  Maybe we should rethink
the communication mechanism ... although I have no immediate ideas for
what else to do.

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2003-03-06 17:15:50
Subject: Re: TODO: DROP COLUMN .. CASCADE
Previous:From: Rod TaylorDate: 2003-03-06 16:55:37
Subject: Re: Row level stats

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