Re: strange performance regression between 7.4 and 8.1

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
(view: Whole thread, Raw)
In response to: strange performance regression between 7.4 and 8.1  ("Alex Deucher")
Responses: Re: strange performance regression between 7.4 and 8.1  ("Alex Deucher")
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:

From: Richard Huxton
Date:
Subject: Re: Insert performance
From: Richard Huxton
Date:
Subject: Re: Insert performance