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

From Guido Neitzer
Subject Re: strange performance regression between 7.4 and 8.1
Date
Msg-id 2D7248A6-38DB-4FE2-A570-6476D5985E85@event-s.net
Whole thread Raw
In response to strange performance regression between 7.4 and 8.1  ("Alex Deucher" <alexdeucher@gmail.com>)
Responses Re: strange performance regression between 7.4 and 8.1  ("Alex Deucher" <alexdeucher@gmail.com>)
List pgsql-performance
On 01.03.2007, at 13:40, Alex Deucher wrote:

> I read several places that the SAN might be to blame, but
> testing with bonnie and dd indicates that the SAN is actually almost
> twice as fast as the scsi discs in the old sun server.  I've tried
> adjusting just about every option in the postgres config file, but
> performance remains the same.  Any ideas?

As mentioned last week:

Did you actually try to use the local drives for speed testing? It
might be that the SAN introduces latency especially for random access
you don't see on local drives.

cug

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re:
Next
From: Bricklen Anderson
Date:
Subject: Re: Estimate the size of the SQL file generated by pg_dump utility