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...