Re: strange performance regression between 7.4 and 8.1 - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: strange performance regression between 7.4 and 8.1
Date
Msg-id 1172854246.20651.210.camel@state.g2switchworks.com
Whole thread Raw
In response to Re: strange performance regression between 7.4 and 8.1  ("Alex Deucher" <alexdeucher@gmail.com>)
List pgsql-performance
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.


pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]
Next
From: Ron
Date:
Subject: Re: strange performance regression between 7.4 and 8.1