Re: Optimisation help

From: dforums <dforums(at)vieonet(dot)com>
To: Alan Hodgson <ahodgson(at)simkin(dot)ca>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Optimisation help
Date: 2008-03-05 00:15:25
Message-ID: 47CDE61D.9070906@vieonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

In regards of update, I have around 10000 updates while a laps of 10 minutes

Is there a settings to optimise updates ?

regards

david

Alan Hodgson a écrit :
> 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.
>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Erik Jones 2008-03-05 00:19:32 Re: Optimisation help
Previous Message dforums 2008-03-05 00:10:18 Re: Optimisation help