Re: How to find size of a table

Jason replied to me off-list:

>>How do I display the size (space used on the disk) of a table or
>>database?

>The actual tables and index files are located in the
>PGSQL_HOME/data/base directory, in separate directories for each
>database you create.
>
>I am unaware of any internal Postgres function which will do this,
>there maybe something in the newer versions perhaps.

I took a snapshot of the directories under base, used the createdb command, and the new directory which appeared was the new database.

I then used the Unix du command to see how much space it used.

Cheers
--
He is a fool who has forgotten what became of his ancestry seven generations before him and who does not care what will become of his progeny seven generations after him -- Kazakh Proverb