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

From Alex Deucher
Subject Re: strange performance regression between 7.4 and 8.1
Date
Msg-id a728f9f90703060725u56b902e7s64ede481536433de@mail.gmail.com
Whole thread Raw
In response to Re: strange performance regression between 7.4 and 8.1  (Guido Neitzer <lists@event-s.net>)
List pgsql-performance
On 3/5/07, Guido Neitzer <lists@event-s.net> wrote:
> On 05.03.2007, at 19:56, Alex Deucher wrote:
>
> > Yes, I started setting that up this afternoon.  I'm going to test that
> > tomorrow and post the results.
>
> Good - that may or may not give some insight in the actual
> bottleneck. You never know but it seems to be one of the easiest to
> find out ...
>

Well, the SAN appears to be the limiting factor.  I set up the DB on
the local scsi discs (software RAID 1) and performance is excellent
(better than the old server).  Thanks for everyone's help.

Alex

pgsql-performance by date:

Previous
From: "Claus Guttesen"
Date:
Subject: Re: Estimate the size of the SQL file generated by pg_dump utility
Next
From: Tom Lane
Date:
Subject: Re: Estimate the size of the SQL file generated by pg_dump utility