[GENERAL] Server getting crushed

[Bryan]

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.

Thanks,
Bryan
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend