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