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

From Liviu Ionescu
Subject Re: performance drop on 8.2.4, reverting to 8.1.4
Date
Msg-id 00a101c79962$de653d50$653e10ac@ilgvaio
Whole thread Raw
In response to Re: performance drop on 8.2.4, reverting to 8.1.4  ("George Pavlov" <gpavlov@mynewplace.com>)
Responses Re: performance drop on 8.2.4, reverting to 8.1.4
Re: performance drop on 8.2.4, reverting to 8.1.4
List 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 by date:

Previous
From: "George Pavlov"
Date:
Subject: Re: performance drop on 8.2.4, reverting to 8.1.4
Next
From: Tom Lane
Date:
Subject: Re: performance drop on 8.2.4, reverting to 8.1.4