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 help. > > > > Fouad Zaryouh > > http://www.flipcore.com > > > > > On Sat, Aug 9, 2008 at 3:18 AM, aravind chandu > <avin_friends@xxxxxxxxx> 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. > > > > This may be of use in recent versions... select pg_size_pretty(pg_database_size('table_name'))
