Re: Server getting crushed - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Server getting crushed
Date
Msg-id 1096903529.10475.10.camel@localhost.localdomain
Whole thread Raw
In response to Server getting crushed  (Bryan <bvest@rhondasworld.com>)
List pgsql-general
On Mon, 2004-10-04 at 08:59, Bryan wrote:
> What would be the recommended server specs to use for a postgresql
> database server that needs to be able to support upto 800 active
> connections at one time, searching a table that in theory could be over
> 2G in size? We have attempted this with a supermicro superserver
> dualproc Xeon 2.8G with 6G of Ram, with a fiber array for database
> storage and its not keeping up. We are pondering either trying a Quad
> Xeon or a Dual Opertron. Unless someone has tips on how we could improve
> the current server.

That depends.  Is your current server I/O or CPU bound, and what have
you done to optimize its performance?


pgsql-general by date:

Previous
From: Bryan
Date:
Subject: Server getting crushed
Next
From: Bruno Wolff III
Date:
Subject: Re: Random not so random