Re: performance drop on 8.2.4, reverting to 8.1.4

From: Vivek Khera <vivek(at)khera(dot)org>
To: PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: performance drop on 8.2.4, reverting to 8.1.4
Date: 2007-05-23 15:47:27
Message-ID: 280803EF-0935-43AD-AD86-73E3A1700BF5@khera.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Vivek Khera 2007-05-23 15:51:49 Re: Tips & Tricks for validating hardware/os
Previous Message Andy 2007-05-23 15:08:49 LIKE search and performance