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:
Bruno Baguette 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 !
on contrib package or contrib subdir from the source is dbsize
Bruno Baguette [EMAIL PROTECTED] schrieb:
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 ?
I'm not sure if this functions available in 8.0:
If not, see in contrib.
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 MFor getting a table size to get an approx size you can do the following:SELECT relpages * 8192 AS size_in_bytesFROM
Bruno Baguette 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 !
This will probably work for you (in bytes - or you could divide by 8
Bruno Baguette wrote:
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.
You've already got several replies. Know that the PG documentation is
excellent. If you visit www.postgresql.org, you will
