469,106 Members | 2,254 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,106 developers. It's quick & easy.

Server getting crushed

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

Nov 23 '05 #1
1 984
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?
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Javier Cortés Cortés | last post: by
9 posts views Thread by Steve Buster | last post: by
4 posts views Thread by bushi | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.