Re: [ADMIN] pg_class reltuples/relpages not updated by autovacuum/vacuum

Kevin Grittner <kevin.grittner@wicourts.gov>

From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: "Alvaro Herrera" <alvherre@commandprompt.com>, "Tom Lane" <tgl@sss.pgh.pa.us>
Cc: "Florian Helmberger" <fh@25th-floor.com>, "pgsql-hackers" <pgsql-hackers@postgresql.org>
Date: 2011-05-25T16:37:24Z
Lists: pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> wrote:
 
> I don't know what client-side code might be looking at
> relpages/reltuples.
 
I know that I find reltuples useful for getting an "accurate enough"
sense of rows in a table (or set of tables) without resorting to
count(*).  I'd be OK with any two of pages, tuples, and density; but
dropping to one would make databases harder to manage, IMV.
 
Personally, I don't have much code that uses those columns;
eliminating an existing column wouldn't involve much pain for me as
long as it could still be derived.
 
-Kevin