| From: | Greg Smith <gsmith(at)gregsmith(dot)com> |
|---|---|
| To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | Thom Brown <thombrown(at)gmail(dot)com>, pgsql general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Detemine database size on Postgres 8.0 |
| Date: | 2009-03-03 00:05:00 |
| Message-ID: | Pine.GSO.4.64.0903021901550.5550@westnet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, 2 Mar 2009, Scott Marlowe wrote:
> Back in the olden days when I was on 8.0 I would just use du -sh to find
> out. and match them up. yeah, I had a script that made it prettier but
> that worked fine.
Not sure what version I started using this trick on:
SELECT relfilenode, relpages * 8 AS kb FROM pg_class;
But that might have been 8.0.
There is an example of a script like you describe on starting on P88 of
Bruce's presentation at
http://momjian.us/main/writings/pgsql/administration.pdf
--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alan Hodgson | 2009-03-03 00:12:05 | Re: How to pipe the psql copy command to Unix 'Date' command |
| Previous Message | John R Pierce | 2009-03-02 23:58:13 | Re: How to pipe the psql copy command to Unix 'Date' command |