On Sat, 2008-08-09 at 04:59 -0400, Fouad Zaryouh wrote:
> 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
aravind chandu <[EMAIL PROTECTED]> schrieb:
> 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
> i
On Sat, Aug 09, 2008 at 12:18:46AM -0700, aravind chandu wrote:
> 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
>
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,
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 suggest
