| From: | "Scott Marlowe" <smarlowe(at)qwest(dot)net> |
|---|---|
| To: | "Bryan" <bvest(at)rhondasworld(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Server getting crushed |
| Date: | 2004-10-04 15:25:29 |
| Message-ID: | 1096903529.10475.10.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2004-10-04 15:57:42 | Re: Random not so random |
| Previous Message | Bryan | 2004-10-04 14:59:28 | Server getting crushed |