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