Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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: Wed, 23 May 2007 11:47:27 -0400
  • Message-id: <280803EF-0935-43AD-AD86-73E3A1700BF5@khera.org> <text/plain>


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.




Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group