db size and VACUUM ANALYZE

Поиск
Список
Период
Сортировка
Искать
От
Marcin Krol
Тема
db size and VACUUM ANALYZE
Дата
Msg-id
4B758B9E.9030007@gmail.com
Список
Дерево обсуждения
db size and VACUUM ANALYZE Marcin Krol <mrkafk@gmail.com>
Re: db size and VACUUM ANALYZE Amitabh Kant <amitabhkant@gmail.com>
Re: db size and VACUUM ANALYZE Marcin Krol <mrkafk@gmail.com>
Re: db size and VACUUM ANALYZE Joao Ferreira gmail <joao.miguel.c.ferreira@gmail.com>
Re: db size and VACUUM ANALYZE Bill Moran <wmoran@potentialtech.com>
Re: db size and VACUUM ANALYZE Marcin Krol <mrkafk@gmail.com>
Re: db size and VACUUM ANALYZE Greg Smith <greg@2ndquadrant.com>
Re: db size and VACUUM ANALYZE Greg Smith <greg@2ndquadrant.com>
Re: db size and VACUUM ANALYZE Scott Marlowe <scott.marlowe@gmail.com>
Hello,

The db in the application I maintain but didn't write (it obviously
makes use of PG, v 8.3), has been systematically growing in size from
about 600M to 1.6G.

At the same time, the performance of the app has degraded significantly
(several times).

So I've done VACUUM ANALYZE on entire db. Nothing. The db did not
decrease in size, the performance stayed the same.

So I backed it up using pg_dump, deleted database, and recreated it from
backup.

The size of db on disk went down to 600M, performance recovered to the
original level.

Why that is so? I thought that VACUUM ANALYZE does everything that is
needed to optimize disk usage?

Regards,
mk

В списке pgsql-general по дате отправления
От: Richard Huxton
Дата:
От: Amitabh Kant
Дата:
Сообщение: Re: db size and VACUUM ANALYZE
FAQ