Re: Database storage bloat

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Database storage bloat
Дата
Msg-id 13514.1081433719@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Database storage bloat  (reina_ga@hotmail.com (Tony Reina))
Список pgsql-admin
reina_ga@hotmail.com (Tony Reina) writes:
> However, a 65X bloat in space seems excessive.

Without concrete details about your schema, it's hard to answer that.
I suspect you made some inefficient choices, but have no data.

For starters you should do a database-wide VACUUM to ensure
pg_class.relpages is up to date, then look to see which tables and
indexes contain the most pages.

            regards, tom lane

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

Предыдущее
От: "Tom Bakken"
Дата:
Сообщение: Re: Out of space
Следующее
От: Tom Lane
Дата:
Сообщение: Re: CONTEXT: in log file