| From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
|---|---|
| To: | Alex Deucher <alexdeucher(at)gmail(dot)com> |
| Cc: | Ron <rjpeace(at)earthlink(dot)net>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: strange performance regression between 7.4 and 8.1 |
| Date: | 2007-03-02 16:50:46 |
| Message-ID: | 1172854246.20651.210.camel@state.g2switchworks.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Fri, 2007-03-02 at 10:03, Alex Deucher wrote:
> On 3/2/07, Ron <rjpeace(at)earthlink(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Anton Rommerskirchen | 2007-03-02 17:45:44 | Re: strange performance regression between 7.4 and 8.1 |
| Previous Message | Scott Marlowe | 2007-03-02 16:35:01 | Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems] |