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
Дата
в 13:50:29
Msg-id
00bc01c7996c$82a66890$653e10ac@ilgvaio
Ответ на
Список
Дерево обсуждения
performance drop on 8.2.4, reverting to 8.1.4 "Liviu Ionescu" <ilgb@livius.net>
Re: performance drop on 8.2.4, reverting to 8.1.4 "Steinar H. Gunderson" <sgunderson@bigfoot.com>
Re: performance drop on 8.2.4, reverting to 8.1.4 "Liviu Ionescu" <ilgb@livius.net>
Re: performance drop on 8.2.4, reverting to 8.1.4 "Steinar H. Gunderson" <sgunderson@bigfoot.com>
Re: performance drop on 8.2.4, reverting to 8.1.4 "Liviu Ionescu" <ilgb@livius.net>
Re: performance drop on 8.2.4, reverting to 8.1.4 "Steinar H. Gunderson" <sgunderson@bigfoot.com>
Re: performance drop on 8.2.4, reverting to 8.1.4 "Liviu Ionescu" <ilgb@livius.net>
Re: performance drop on 8.2.4, reverting to 8.1.4 "Steinar H. Gunderson" <sgunderson@bigfoot.com>
Re: performance drop on 8.2.4, reverting to 8.1.4 "Liviu Ionescu" <ilgb@livius.net>
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 "Liviu Ionescu" <ilgb@livius.net>
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 "Liviu Ionescu" <ilgb@livius.net>
Re: performance drop on 8.2.4, reverting to 8.1.4 Guido Neitzer <lists@event-s.net>
Re: performance drop on 8.2.4, reverting to 8.1.4 Vivek Khera <vivek@khera.org>
Re: performance drop on 8.2.4, reverting to 8.1.4 Tom Lane <tgl@sss.pgh.pa.us>
Re: performance drop on 8.2.4, reverting to 8.1.4 "Steven Flatt" <steven.flatt@gmail.com>
Re: performance drop on 8.2.4, reverting to 8.1.4 Tom Lane <tgl@sss.pgh.pa.us>
Re: performance drop on 8.2.4, reverting to 8.1.4 "Steven Flatt" <steven.flatt@gmail.com>
Re: performance drop on 8.2.4, reverting to 8.1.4 Tom Lane <tgl@sss.pgh.pa.us>
Re: performance drop on 8.2.4, reverting to 8.1.4 Alvaro Herrera <alvherre@commandprompt.com>
Re: performance drop on 8.2.4, reverting to 8.1.4 Tom Lane <tgl@sss.pgh.pa.us>
Re: performance drop on 8.2.4, reverting to 8.1.4 "Steven Flatt" <steven.flatt@gmail.com>
Re: performance drop on 8.2.4, reverting to 8.1.4 "Steinar H. Gunderson" <sgunderson@bigfoot.com>
> It is arguable, that updating the DB software version in an 
> enterprise environment requires exactly that: check all 
> production queries on the new software to identify any 
> issues. In part, this is brought on by the very tuning that 
> you performed against the previous software. Restore the 8.1 
> DB into 8.2. Then run the queries against both versions to 
> evaluate functioning and timing.

you're right. my previous message was not a complain, was a warning for
others to avoid the same mistake. I was overconfident and got bitten. in the
future I'll check my queries on 8.2/8.3/... on a development configuration
before upgrading the production server.

regards,

Liviu

В списке pgsql-performance по дате отправления
От: Steinar H. Gunderson
Дата:
Сообщение: Re: CPU Intensive query
От: Mark Harris
Дата:
FAQ