From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Alex Deucher <alexdeucher@gmail.com>
Cc: Ron <rjpeace@earthlink.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: strange performance regression between 7.4 and 8.1
Date: Fri, 02 Mar 2007 10:50:46 -0600
Message-ID: <1172854246.20651.210.camel@state.g2switchworks.com> (raw)
In-Reply-To: <a728f9f90703020803r2ab76789sa63def90642fe5c@mail.gmail.com>
References: <a728f9f90703011244r577d56d7y422ab4bd71bb760e@mail.gmail.com>
<82slco6n9t.fsf@mid.bfk.de>
<a728f9f90703020716g45b2d281u9894973abad3e68a@mail.gmail.com>
<E1HN9zd-0001tV-Gi@elasmtp-galgo.atl.sa.earthlink.net>
<a728f9f90703020803r2ab76789sa63def90642fe5c@mail.gmail.com>
On Fri, 2007-03-02 at 10:03, Alex Deucher wrote:
> On 3/2/07, Ron <rjpeace@earthlink.net> wrote:
> > At 10:16 AM 3/2/2007, Alex Deucher wrote:
> > d= you went from local HD IO to a SAN
> > (many differences hidden in that one line... ...and is the physical
> > layout of tables and things like pg_xlog sane on the SAN?)
> >
> >
> > ...and you did this by just pulling over the old DB onto the new HW?
> >
>
> We rebuild the DB from scratch on the new server. Same table
> structure though. We reloaded from the source material directly.
I would REALLY recommend testing this machine out with a simple software
RAID-1 pair of SCSI or SATA drives just to eliminate or confirm the SAN
as the root problem.
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: smarlowe@g2switchworks.com, alexdeucher@gmail.com, rjpeace@earthlink.net
Subject: Re: strange performance regression between 7.4 and 8.1
In-Reply-To: <1172854246.20651.210.camel@state.g2switchworks.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