Sophie

Sophie

distrib > Mandriva > 9.1 > ppc > media > updates > by-pkgid > 077598a298d69e4a8da27f7098a22372 > files > 65

postgresql-contrib-7.3.2-5.1.91mdk.ppc.rpm

This module contains two functions that report the size of a given
database or relation.  E.g.,

SELECT database_size('template1');
SELECT relation_size('pg_class');

These functions report the actual file system space.  Thus, users can
avoid digging through the details of the database directories.

Copy this directory to contrib/dbsize in your PostgreSQL source tree.
Then just run make; make install.  Finally, load the functions into any
database using dbsize.sql.

When computing the size of a table, it does not include TOAST or index
disk space.