Re: Calculating size of the database tables - Mailing list pgsql-admin

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hi,

On Thu, 10 Jun 2004 akuppachi@hss.hns.com wrote:

<snip>
> I would appreciate any pointers to finding out the correct size occupied by
> my database tables. Will the physical size of the "data" folder (as given
> by 'ls' command) give me the true size, or is there any other sql command
> that i can use to get this information?  I am using PostgreSQL, version
> 7.4.1 server libraries.

Please see contrib/dbsize. From README file:

"
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.
"

Regards,
- --
Devrim GUNDUZ
devrim~gunduz.org                devrim.gunduz~linux.org.tr
            http://www.tdmsoft.com
            http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFAyD48tl86P3SPfQ4RAu+dAJ9L4sfyaR9VRAA9jATcHxB/p9+lLQCg4/3a
jlDyuD1rOxNrij7UqX5xuKs=
=B0Mo
-----END PGP SIGNATURE-----