Re: ANALYZE and index/stats degradation

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Re: ANALYZE and index/stats degradation
Дата
Msg-id 87tzsm4yyn.fsf@oxford.xeocode.com
обсуждение исходный текст
Ответ на Re: ANALYZE and index/stats degradation  ("Jeroen T. Vermeulen" <jtv@xs4all.nl>)
Ответы Re: ANALYZE and index/stats degradation
Список pgsql-hackers
"Jeroen T. Vermeulen" <jtv@xs4all.nl> writes:

> Actually, come to think of it, I don't think I'd want any vacuums at all
> on this particular table.  Just the analyze on the primary key, no
> vacuums, no statistics on anything else.  Unfortunately it's not just one
> table, but a set of tables that can be created dynamically.  I could
> change that, but in this particular case I don't think I should.

The way you described it there were records being inserted and later deleted.
Why wouldn't you need vacuums?

Or are all the records eventually deleted and then the table truncated or
dropped before the next batch of inserts?

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com



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

Предыдущее
От: "Jeroen T. Vermeulen"
Дата:
Сообщение: Re: ANALYZE and index/stats degradation
Следующее
От: "Simon Riggs"
Дата:
Сообщение: Re: Configurable Additional Stats