On Fri, Jun 24, 2005 at 05:10:15PM +0100, Dave Page wrote: > You have pg_database_size(oid) and database_size(name). Afaict, the > latter is equivalent to: > > SELECT pg_database_size((SELECT oid FROM pg_database WHERE datname = > 'foo')) > > My main concern is that the names are inconsistent for no obvious > reason. I also questioned whether or not the bloat of an additional > function is worthwhile for what is probably a very small number of psql > users that might use it (probably quite rarely), however if people say > they would use it and that it's wothwhile, I wouldn't argue with it's > inclusion.
ISTM it would be better to just add this info into newsysviews. Anyone who regularly queries against the catalog from psql is going to want to have them installed anyway. We could either add exact size info to pg_*_table_storage (http://lnk.nu/cvs.pgfoundry.org/39q.sql) or create a new view with the file sizes. -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?" ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
