Re: performance drop on 8.2.4, reverting to 8.1.4

Поиск
Список
Период
Сортировка
От Vivek Khera
Тема Re: performance drop on 8.2.4, reverting to 8.1.4
Дата
Msg-id 280803EF-0935-43AD-AD86-73E3A1700BF5@khera.org
обсуждение исходный текст
Ответ на Re: performance drop on 8.2.4, reverting to 8.1.4  ("Liviu Ionescu" <ilgb@livius.net>)
Список pgsql-performance
On May 18, 2007, at 11:40 AM, Liviu Ionescu wrote:

> 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

Doing any major software version upgrade on any production system is
suicidal without first vetting your entire stack against the proposed
upgrades.  For best results, verify even minor version upgrades on
test systems first, with full testing of your app.

We do.  It has saved us many times.


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

Предыдущее
От: "Andy"
Дата:
Сообщение: LIKE search and performance
Следующее
От: Vivek Khera
Дата:
Сообщение: Re: Tips & Tricks for validating hardware/os