Re: Poor delete performance AFTER vacuum analyze

Список
Период
Сортировка
От Tom Lane
Тема Re: Poor delete performance AFTER vacuum analyze
Дата
Msg-id 19929.1058676291@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Poor delete performance AFTER vacuum analyze  ("Jeremy M. Guthrie")
Ответы Re: 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, )
"Jeremy M. Guthrie" <> writes:
>     My system will run great after a full vacuum(as I would expect).  It will run
> all day long taking only 3-5 seconds to run and deal with approximately
> 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.

Could we see EXPLAIN ANALYZE for the deletion query in both the fast and
slow states?

            regards, tom lane

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

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