Re: Table size

On Thu, Jun 14, 2007 at 06:10:15PM +0530, Shyam Sunder Rai wrote:
> How can I calculate a table size in postgres ?

To find the size of an existing table use pg_relation_size() or
pg_total_relation_size() (8.1 and later; in earlier versions use
the functions in contrib/dbsize).

http://www.postgresql.org/docs/8.2/interactive/functions-admin.html#FUNCTIONS-ADMIN-DBSIZE

Or did you want to estimate the size of a table given the number
and types of its columns and the number of rows?

--
Michael Fuhr