Re: strange performance regression between 7.4 and 8.1

From: "Alex Deucher" <alexdeucher(at)gmail(dot)com>
To: "Guido Neitzer" <lists(at)event-s(dot)net>
Cc: "PostgreSQL Performance" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: strange performance regression between 7.4 and 8.1
Date: 2007-03-06 15:25:30
Message-ID: a728f9f90703060725u56b902e7s64ede481536433de@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 3/5/07, Guido Neitzer <lists(at)event-s(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2007-03-06 15:31:37 Re: Estimate the size of the SQL file generated by pg_dump utility
Previous Message Claus Guttesen 2007-03-06 15:09:15 Re: Estimate the size of the SQL file generated by pg_dump utility