Re: Query Planning time increased 3 times on 7.1 compared to 7.0.3

Поиск
Список
Период
Сортировка
От Christof Petig
Тема Re: Query Planning time increased 3 times on 7.1 compared to 7.0.3
Дата
Msg-id 3AA64EFF.EA49902A@petig-baender.de
обсуждение исходный текст
Ответ на Query Planning time increased 3 times on 7.1 compared to 7.0.3  (Christof Petig <christof.petig@wtal.de>)
Список pgsql-hackers
Tom Lane wrote:

> Christof Petig <christof.petig@wtal.de> writes:
> > We noticed that after upgrading to 7.1beta[245] the execution time for
> > some often used queries went up by a factor of 2 or more.
>
> I get the desired plan after doing VACUUM ANALYZE ...
>
>                         regards, tom lane

I apologize. I must have been smoking something when I did the vacuum
analyze. And my nightly script did not work. 7.1 is much faster.

Christof




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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: WAL & SHM principles
Следующее
От: Olivier PRENANT
Дата:
Сообщение: Re: Contributions?