Re: VACUUM FULL ANALYZE on 8.1.4 is slower then on 8.0

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: VACUUM FULL ANALYZE on 8.1.4 is slower then on 8.0
Дата
Msg-id 11372.1161268371@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: VACUUM FULL ANALYZE on 8.1.4 is slower then on 8.0  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-performance
Дерево обсуждения 
Michael Fuhr <mike@fuhr.org> writes:
> On Thu, Oct 19, 2006 at 03:30:35PM +0200, Andrzej Zawadzki wrote:
>> After upgrade PostgreSQL from 8.0 to 8.1.4 a VACUUM FULL ANALYZE
>> process is much slower, from logs:

> Is it possible that 8.1 was built with --enable-cassert and 8.0
> wasn't?  What does "SHOW debug_assertions" show on each server?

Different vacuum delay settings maybe?

            regards, tom lane

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

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: VACUUM FULL ANALYZE on 8.1.4 is slower then on 8.0
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: DB Performance decreases due to often written/accessed