From: Francisco Reyes <lists@stringsutils.com>
To: Tory M Blue <tmblue@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Running 9 in production? Sticking with 8.4.4 for a while?
Date: Wed, 27 Oct 2010 11:19:43 -0400
Message-ID: <cone.1288192783.584948.5695.1000@shelca> (raw)
References: <AANLkTinLE8vF4uUaY6gspbn76g4sxbaThdNkHj8kXTqj@mail.gmail.com>
Tory M Blue writes:
> Just looking for 9.0 feedback (understand it's still quite new).
Although not 9.0 feedback per se.. but something to consider...
I am moving a number of machines from 8.1 to 8.4.
We use a rolling procedure with a spare:
machine A running 8.1
machine B is prepped with 8.4
change names and IPs
keep old A for a bit just in case...
The last replacement we noticed a big regression in performance. Upon
inspection the machine we replaced was 3.7.. Both 8.X and 8.X have serious
problems with a particualr query (dealing with it on performance now).
So I guess what I am trying to say... you need to test with your own data
set. That lone 8.3.7 machine was literally a fluke. We were going to move
all 8.1 to 8.4.. but at one point did one in 8.3. If we had not done that we
would not have noticed that both 8.1 and 8.4 have problems with some of our
queries.
I am even leaning now to have a lab with 8.3 for testing queries.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: lists@stringsutils.com, tmblue@gmail.com
Subject: Re: Running 9 in production? Sticking with 8.4.4 for a while?
In-Reply-To: <cone.1288192783.584948.5695.1000@shelca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox