| 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? |