From: dforums <dforums@vieonet.com>
To: Alan Hodgson <ahodgson@simkin.ca>
Cc: pgsql-performance@postgresql.org
Subject: Re: Optimisation help
Date: Wed, 05 Mar 2008 00:15:25 +0000
Message-ID: <47CDE61D.9070906@vieonet.com> (raw)
In-Reply-To: <200803041303.58321@hal.medialogik.com>
References: <47CDCB62.9070302@vieonet.com>
<200803041303.58321@hal.medialogik.com>
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@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.
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dforums@vieonet.com, ahodgson@simkin.ca
Subject: Re: Optimisation help
In-Reply-To: <47CDE61D.9070906@vieonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox