"Joshua D. Drake" wrote: > Bill wrote: > > I am new to PostgreSQL and just beginning to learn the product. I > > will probrobably be using it exclusively on Windows. > > > > I was surprised to learn that PostgreSQL creates a new process for > > each connection. Doesn't this severely limit its scalability by > > consuming resources rapidly on the server as the number of user > > increases? > > The Windows version is not anywhere near as scalable as the unix > versions. Depending on your hardware you will top out a Windows > installation about about 350-400 connections. You can get more out of > Windows by modifying the registry but I am unsure of how far it will > go. > > I have Linux installations that happily hum along with 2000-5000 > connections. > > So in answer to your question, in general -- no the process > methodology we use does not limit scalability and it makes our code > base much simpler that the equivalent threading model. > > Sincerely, > > Joshua D. Drake Thanks. How much memory does PostgreSQL consume with 2000 connections? Which Linux distribution do you prefer? -- .Bill.
