Re: Disk space occupied by a table in postgresql

Hi Aravind,

Run the following query

SELECT relname, reltuples, relpages * 8 / 1024 AS "MB" FROM pg_class ORDER
BY relpages DESC;

relname = table name
relpages = size in MB
reltuples = number of rows.

Hope this help.

Fouad Zaryouh

http://www.flipcore.com

On Sat, Aug 9, 2008 at 3:18 AM, aravind chandu <avin_friends(at)yahoo(dot)com>wrote:

> Hello,
>
> I installed postgresql on linux system, I create a
> table and inserted a large data into the table what I would like to know is
> how to calculate the disk space occupied by the table .Is there any
> procedure to find it out or simply a command .Please give me some
> suggestion.
>
>
> Thank You,
> Avin.
>
>