Re: strange performance regression between 7.4 and 8.1

From: Guido Neitzer <lists(at)event-s(dot)net>
To: PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: strange performance regression between 7.4 and 8.1
Date: 2007-03-06 02:14:48
Message-ID: 2D7248A6-38DB-4FE2-A570-6476D5985E85@event-s.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Bricklen Anderson 2007-03-06 02:19:54 Re: Estimate the size of the SQL file generated by pg_dump utility
Previous Message Tom Lane 2007-03-06 01:54:52 Re: