Re: performance drop on 8.2.4, reverting to 8.1.4

From: "Liviu Ionescu" <ilgb(at)livius(dot)net>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: performance drop on 8.2.4, reverting to 8.1.4
Date: 2007-05-18 15:40:31
Message-ID: 00a101c79962$de653d50$653e10ac@ilgvaio
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2007-05-18 15:54:49 Re: performance drop on 8.2.4, reverting to 8.1.4
Previous Message George Pavlov 2007-05-18 15:13:08 Re: performance drop on 8.2.4, reverting to 8.1.4