<[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
