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.
>
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 |