Re: Hardware for PostgreSQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wednesday 31 October 2007 12:45, Ketema wrote:
> I am trying to build a very Robust DB server that will support 1000+
> concurrent users (all ready have seen max of 237 no pooling being
> used).  I have read so many articles now that I am just saturated.  I
> have a general idea but would like feedback from others.
>

Most of the other answers you've gotten have been pretty good, but I had some 
questions on the above; specifically is there a reason you're avoid pooling? 
(something like pgbouncer can work wonders).  Are your 1000+ concurrent users 
working in something like a web environment, where they won't need a 1:1 
user:connection map to service them all, or are these going to be more 
permanent connections into the system?  FWIW I'd done 1000 connections 
simultaneous on pretty basic hardware, but you need to have the right kind of 
workloads to be able to do it. 

>
> Who has built the biggest baddest Pg server out there and what do you
> use?
>

While I'm not sure this will be that much help, I'd feel remisce if I didn't 
point you to it... 
http://www.lethargy.org/~jesus/archives/66-Big-Bad-PostgreSQL.html

-- 
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux