Re: Optimisation help

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Optimisation help
Date: 2008-03-04 21:03:58
Message-ID: 200803041303.58321@hal.medialogik.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tuesday 04 March 2008, dforums <dforums(at)vieonet(dot)com> wrote:
> Hello
>
>
> We hace a Quad Xeon server, with 8GO of ram, sata II 750Go
>
>
> I suppose the main problem is from database server settings.

No, the problem is your hard drive is too slow. One drive can only do maybe
150 seeks per second.

Oh, and updates in PostgreSQL are expensive. But mostly I'd say it's your
drive.

--
Alan

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message dforums 2008-03-04 22:21:22 Optimisation help
Previous Message Chris Kratz 2008-03-04 18:16:15 Re: Ramifications of turning off Nested Loops for slow queries