Re: performance drop on 8.2.4, reverting to 8.1.4

Поиск
Список
Период
Сортировка
От Liviu Ionescu
Тема Re: performance drop on 8.2.4, reverting to 8.1.4
Дата
Msg-id 00a101c79962$de653d50$653e10ac@ilgvaio
обсуждение исходный текст
Ответ на Re: performance drop on 8.2.4, reverting to 8.1.4  ("George Pavlov" <gpavlov@mynewplace.com>)
Ответы Re: performance drop on 8.2.4, reverting to 8.1.4  (Kenneth Marshall <ktm@rice.edu>)
Re: performance drop on 8.2.4, reverting to 8.1.4  (Vivek Khera <vivek@khera.org>)
Список pgsql-performance
> under some alignments of the planets 8.1 has similar problems.

8.1 might have similar problems, but the point here is different: if what
was manually tuned to work in 8.1 confuses the 8.2 planner and performance
drops so much (from 2303 to 231929 ms in my case) upgrading a production
machine to 8.2 is a risky business. I probably have hundreds of sql
statements in my application, some of them quite complex, and it is not
reasonable to check all of them in order to certify them to be 8.2
compliant.

regards,

Liviu


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

Предыдущее
От: "George Pavlov"
Дата:
Сообщение: Re: performance drop on 8.2.4, reverting to 8.1.4
Следующее
От: Tom Lane
Дата:
Сообщение: Re: performance drop on 8.2.4, reverting to 8.1.4