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