Re: best practice to avoid table bloat?

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: best practice to avoid table bloat?
Дата
Msg-id 502D173702000025000497D1@gw.wicourts.gov
обсуждение исходный текст
Ответ на best practice to avoid table bloat?  ("Anibal David Acosta" <aa@devshock.com>)
Ответы Re: best practice to avoid table bloat?  ("Anibal David Acosta" <aa@devshock.com>)
Список pgsql-performance
"Anibal David Acosta" <aa@devshock.com> wrote:

> if I have a table that daily at night is deleted about 8 millions
> of rows (table maybe has 9 millions) is recommended to do a vacuum
> analyze after delete completes or can I leave this job to
> autovacuum?

Deleting a high percentage of the rows should cause autovacuum to
deal with the table the next time it wakes up, so an explicit VACUUM
ANALYZE shouldn't be needed.

> For some reason for the same amount of data every day postgres
> consume a little more.

How are you measuring the data and how are you measuring the space?
And what version of PostgreSQL is this?

-Kevin


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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: best practice to avoid table bloat?
Следующее
От: "Anibal David Acosta"
Дата:
Сообщение: Re: best practice to avoid table bloat?