Horton

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

Chester Kustarz <chester@arbor.net>

View thread View on postgr.es
From: Chester Kustarz <chester@arbor.net>
To: "Matthew T. O'Connor" <matthew@zeut.net>
Cc: pgsql-performance@postgresql.org, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2003-11-21T23:53:26Z
Lists: pgsql-hackers, pgsql-performance 
On Fri, 21 Nov 2003, Matthew T. O'Connor wrote:
> >> Do you know of an easy way to get a
> >>count of the total pages used by a whole cluster?
> >
> >Select sum(relpages) from pg_class.

You might want to exclude indexes from this calculation. Some large
read only tables might have indexes larger than the tables themselves.