Re: How can I known the size of a database, table by table ?

The space occupied by your database and tables can be found this way:

# select oid from pg_database where datname='mybase';

oid
-------
17239
(1 row)

$ du -hs data/base/17239
13.5 M

For getting a table size to get an approx size you can do the following:

SELECT relpages * 8192 AS size_in_bytes
FROM pg_class
WHERE

relnamespace = (SELECT oid FROM pg_namespace WHERE nspname = '<schema
name>') AND

relname = '<table name>';

/Shoaib

On 3/27/06, Bruno Baguette < pgsql-ml(at)baguette(dot)net> wrote:
>
> Hello,
>
> I works on a PostgreSQL 8.0.4 database, and I would like to known the
> size (in bytes, Mbytes or anything else) of that database, for each table.
>
> How can I do that ?
>
> Thanks in advance !
>
> --
> Bruno BAGUETTE
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>