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:10:18
Message-ID: 47CDE4EA.8020206@vieonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

tX for your reply,

I do not have more information on disk speed. I'll get it latter.

But My most fear is that for now the database is only of 10 Go.

But I will have to increase it 10 times during the next six month I'm
afraid that these problems will increase.

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

Browse pgsql-performance by date

  From Date Subject
Next Message dforums 2008-03-05 00:15:25 Re: Optimisation help
Previous Message Greg Smith 2008-03-04 22:59:47 Re: Optimisation help