Re: performance drop on 8.2.4, reverting to 8.1.4 - Mailing list pgsql-performance

From Vivek Khera
Subject Re: performance drop on 8.2.4, reverting to 8.1.4
Date
Msg-id 280803EF-0935-43AD-AD86-73E3A1700BF5@khera.org
Whole thread Raw
In response to Re: performance drop on 8.2.4, reverting to 8.1.4  ("Liviu Ionescu" <ilgb@livius.net>)
List 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 by date:

Previous
From: "Andy"
Date:
Subject: LIKE search and performance
Next
From: Vivek Khera
Date:
Subject: Re: Tips & Tricks for validating hardware/os