Re: Optimisation help - Mailing list pgsql-performance

From Alan Hodgson
Subject Re: Optimisation help
Date
Msg-id 200803041303.58321@hal.medialogik.com
Whole thread Raw
In response to Optimisation help  (dforums <dforums@vieonet.com>)
Responses Re: Optimisation help  (dforums <dforums@vieonet.com>)
Re: Optimisation help  (dforums <dforums@vieonet.com>)
List pgsql-performance
On Tuesday 04 March 2008, dforums <dforums@vieonet.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

pgsql-performance by date:

Previous
From: dforums
Date:
Subject: Optimisation help
Next
From: dforums
Date:
Subject: Re: Optimisation help