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 по дате отправления:

Предыдущее
От: "V S P"
Дата:
Сообщение: [Q] single image Table across multiple PG servers
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Checkpoint Tuning Question