Re: Poor delete performance AFTER vacuum analyze

Список
Период
Сортировка
От Dennis Björklund
Тема Re: Poor delete performance AFTER vacuum analyze
Дата
Msg-id Pine.LNX.4.44.0307200738560.4146-100000@zigo.dhs.org
обсуждение исходный текст
Ответ на Poor delete performance AFTER vacuum analyze  ("Jeremy M. Guthrie")
Список pgsql-performance
Дерево обсуждения
Poor delete performance AFTER vacuum analyze  ("Jeremy M. Guthrie", )
 Re: Poor delete performance AFTER vacuum analyze  (Tom Lane, )
  Re: Poor delete performance AFTER vacuum analyze  ("Jeremy M. Guthrie", )
   Re: Poor delete performance AFTER vacuum analyze  (Tom Lane, )
 Re: Poor delete performance AFTER vacuum analyze  (Dennis Björklund, )
On Sat, 19 Jul 2003, Jeremy M. Guthrie wrote:

> 100megs of new data each day.  However, the instant the system finishes only
> a 'vacuum analyze', the whole thing slows WAY down to where each run can take
> 10-15 minutes.

Have you run EXPLAIN ANALYZE on the delete query before and after the
vacuum? Does it explain why it goes slower?

--
/Dennis


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

Предыдущее
От: Dennis Björklund
Дата:
Сообщение: Re: Poor delete performance AFTER vacuum analyze
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Moving postgresql.conf tunables into 2003...