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
Список
Дерево обсуждения
Re: Query Planning time increased 3 times on 7.1 compared to 7.0.3 Christof Petig <christof@petig-baender.de>
Tom Lane wrote:

> Christof Petig  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?
FAQ