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. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly