Re: storage calculations

<pgboy(at)guthrie(dot)charm(dot)net> writes:
> i've been browsing the documentation online, and i can't
> find where the storage layouts for tables and indexes are
> explained.
>
> i'd like to be able to figure out, given a table or two
> with a simple schema (no ineritance) and some indexes, and
> a number of rows currently in these tables, how much disk
> space is being used.

oid2name | grep <your_db_name>

give you the name of the directory where the database is stored
inside your $PGDATA directory.

In order to now the name of the file that correspond to your
table:

oid2name -d <your_db_name> -t <your_table_name>

Regards
Gaetano Mendola