Re: Disk space occupied by a table in postgresql

Поиск
Список
Период
Сортировка
От Fouad Zaryouh
Тема Re: Disk space occupied by a table in postgresql
Дата
Msg-id e6a067860808090159v299004e9v1cebfdec9da82d24@mail.gmail.com
обсуждение исходный текст
Ответ на Disk space occupied by a table in postgresql  (aravind chandu <avin_friends@yahoo.com>)
Ответы Re: Disk space occupied by a table in postgresql  (Reid Thompson <Reid.Thompson@ateb.com>)
Список pgsql-general
Дерево обсуждения
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@yahoo.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.


В списке pgsql-general по дате отправления:

Предыдущее
От: aravind chandu
Дата:
Сообщение: Disk space occupied by a table in postgresql
Следующее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: Disk space occupied by a table in postgresql