Re: db grows and grows

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: db grows and grows
Дата
Msg-id Pine.LNX.4.33.0206181239450.18262-100000@polluelo.lab.protecne.cl
обсуждение исходный текст
Ответ на db grows and grows  ("Bjoern Metzdorf" <bm@turtle-entertainment.de>)
Список pgsql-general
On Tue, 18 Jun 2002, Bjoern Metzdorf wrote:

> I have a 3 GB (fs based) large pgdata directory. I regularly do vacuums
> every 15 minutes and vacuums with analyzing every night.
>
> After dumping the whole db (pg_dump -c db), dropping and creating the db,
> reinserting the dump and vacuuming again, my pgdata directory only contains
> 1 GB. The dump had no errors, all data has been saved and reinserted.

Your indexes are probably growing. In extant versions, VACUUM doesn't
shrink them, so you should do it manually using REINDEX.  There's a
contributed script that does it in a reasonably automated way, like the
vacuum script does.  Look in the archives.


> Shouldn't the vacuuming take care of this?

Yes IMVHO, but at present it doesn't.

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)


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

Предыдущее
От: Kenny H Klatt
Дата:
Сообщение: pgdump question
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: db grows and grows