Re: How can I find out the space used on disk for a table/index

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: How can I find out the space used on disk for a table/index
Дата
Msg-id 1247551309.22064.16.camel@ayaki
обсуждение исходный текст
Ответ на Re: How can I find out the space used on disk for a table/index  (Greg Stark <gsstark@mit.edu>)
Список pgsql-general
On Mon, 2009-07-13 at 00:53 +0100, Greg Stark wrote:

> Also counter-productive since vacuum full actually causes indexes to
> grow, not shrink.

As a result, your indexes may be quite bloated. Consider REINDEXing them
to get them back to sensible sizes, then avoiding VACUUM FULL.

--
Craig Ringer


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