Re: frustration with database size

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: frustration with database size
Дата
Msg-id 4923.1011555451@sss.pgh.pa.us
обсуждение исходный текст
Ответ на frustration with database size  (Andrew Gould <andrewgould@yahoo.com>)
Ответы Re: frustration with database size  (Andrew Gould <andrewgould@yahoo.com>)
Список pgsql-general
Andrew Gould <andrewgould@yahoo.com> writes:
> The process above resulted in an **increase** in
> database size from 12GB to 14GB.
> I'm both surprised and stumped.

Seems odd to me too.  Like Einar, I am wondering about index sizes.

An easy way to get some data is to do a VACUUM so that the relpages
statistics are up to date, and then do

select relname,relkind,relpages from pg_class order by relpages desc;

            regards, tom lane

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

Предыдущее
От: "Tim Barnard"
Дата:
Сообщение: Re: Clarification question
Следующее
От: Jochem van Dieten
Дата:
Сообщение: PL/pgSQL: dynamic tablename