From: | Chester Kustarz <chester(at)arbor(dot)net> |
---|---|
To: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
Cc: | pgsql-performance(at)postgresql(dot)org, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [HACKERS] More detail on settings for pgavd? |
Date: | 2003-11-21 23:53:26 |
Message-ID: | Pine.BSO.4.44.0311211842200.19584-100000@detroit.arbor.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Eric Davies | 2003-11-22 00:27:33 | mechanism used to store images in Postgres |
Previous Message | Tom Lane | 2003-11-21 23:04:56 | Re: [HACKERS] More detail on settings for pgavd? |
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Stark | 2003-11-22 00:51:17 | Re: [PERFORM] More detail on settings for pgavd? |
Previous Message | Tom Lane | 2003-11-21 23:04:56 | Re: [HACKERS] More detail on settings for pgavd? |