From: Carlos Moreno <morenopg@mochima.com>
To: pgsql-performance@postgresql.org
Subject: Re: "Mysterious" issues with newly installed 8.3
Date: Mon, 13 Oct 2008 15:56:58 -0400
Message-ID: <48F3A80A.5070602@mochima.com> (raw)
In-Reply-To: <dcc563d10810130828t2d48c813r5abd56e014e5e27f@mail.gmail.com>
References: <48EE98FE.60100@mochima.com>
<a1ec7d000810091734k60cee7d7qb95470936ad461c1@mail.gmail.com>
<Pine.GSO.4.64.0810100345010.26609@westnet.com>
<48F3615B.4050705@mochima.com>
<dcc563d10810130828t2d48c813r5abd56e014e5e27f@mail.gmail.com>
Scott Marlowe wrote:
> On Mon, Oct 13, 2008 at 8:55 AM, Carlos Moreno <morenopg@mochima.com> wrote:
>
>> I guess my logical next step is what was suggested by Scott --- install
>> 8.2.4 and repeat the same tests with this one; that should give me
>> interesting information.
>>
>
> I'd suggest updating to the latest 8.2.x update as well. Not for
> performance tuning reasons but to make sure you're data's not at risk
> etc... I think there's a good year or more of updates missing from the
> 8.2.4 branch.
>
Of course --- but do keep in mind that the reason for this was to
do a meanigful comparison; SQLs being run and clicked on an
8.2.4 system vs. the same SQLs being run on a different hardware
with the exact same software. If for some reason I conclude that
the 8.2 seems to offer better performance with the given hardware,
then of course I would go with the latest 8.2.x ...
If you're referring to the existing installation, well, yeah, I've been
meaning to upgrade it, but I guess now that we are going with a
hardware upgrade as well, then the software upgrade will be a
side-effect of the maneuver.
Thanks,
Carlos
--
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: morenopg@mochima.com
Subject: Re: "Mysterious" issues with newly installed 8.3
In-Reply-To: <48F3A80A.5070602@mochima.com>
* 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