Re: Optimisation help

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your Subscription:
http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-performance

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux