Re: data directory growing huge

Поиск
Список
Период
Сортировка
От Doug McNaught
Тема Re: data directory growing huge
Дата
Msg-id m3smmm9sp7.fsf@varsoon.wireboard.com
обсуждение исходный текст
Ответ на data directory growing huge  ("Esger Abbink" <pggeneral@bumblebeast.com>)
Список pgsql-general
"Esger Abbink" <pggeneral@bumblebeast.com> writes:

> On two production server (7.2rc2) of ours the data directory is growing
> to very large sizes while the data that is actually in the db's isnt 1.
> that large and 2. growing.

You're running a release candidate of 7.2?  That's pretty old and has
known bugs...

Your problem, however, is probably index bloat, which is not fixed by
VACUUM in the version you're running.  If you REINDEX you should see
storage usage go back to normal.

The upcoming 7.4 should suffer much less from the index bloat problem.

-Doug

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

Предыдущее
От: Shridhar Daithankar
Дата:
Сообщение: Re: data directory growing huge
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: [ADMIN] Fatal error: Allowed memory size of 8388608