Is there a way, from within Postgresql, to view the filesize usage of its databases and tables? That might be the best approach and sounds easier than looking at the raw data directory.
On Wed Jan 31, 2007 at 02:35:16PM -0800, larry price wrote: > short answer: you can but it's ugly > > longer answer: > start looking at the pg_catalog.* relations (use \d from psql prompt) > as I understand it the files under $PG_DATA/base/ are named after > oid's for tables and relations, but there are a lot of subtleties, and > the whole point of a DBMS is to manage that bookkeeping for you. _______________________________________________ EUGLUG mailing list euglug@euglug.org http://www.euglug.org/mailman/listinfo/euglug
