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 gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
