Re: How to find size of a table

Поиск
Список
Период
Сортировка
От Tom Robinson
Тема Re: How to find size of a table
Дата
Msg-id 20010820071649-r01010700-57a54948-0910-0108@203.79.95.108
обсуждение исходный текст
Ответ на How to find size of a table  (Tom Robinson <tom.robinson@paradise.net.nz>)
Список pgsql-novice
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
thenew 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
becomeof his progeny seven generations after him -- Kazakh Proverb 

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

Предыдущее
От: travep
Дата:
Сообщение: Re: Queries seem to lock up shell session
Следующее
От: "macky"
Дата:
Сообщение: Altering pg_conndefaults