[EMAIL PROTECTED] (Peter Eisentraut) writes: > Jose Mendoza wrote: >> I intend to use the postgreSQL in several projects that requiere to >> attend about 1000 - 2500 users in a chain of retail stores. Is is >> that possible? Or is beyond that the postgresql possibilities? > > That is certainly easily possible.
Well, a couple thousand concurrent users, on a fairly small server, may prove challenging. The database connections alone will chew a fair bit of memory, and postmasters rather more. It may be a nifty idea to build an application that sits in between that queues up requests so that the DBMS doesn't have to cope with managing thousands of concurrent connections, that are not, individually, terribly busy, but instead has 50 connections that are kept pretty busy. IBM sells a product called MQSeries that does that; I seem to recall that Microsoft paid an Israeli company to develop a 'clone,' now called MSMQ. Apparently pretty good stuff, where applicable... -- let name="cbbrowne" and tld="libertyrms.info" in String.concat "@" [name;tld];; <http://dev6.int.libertyrms.com/> Christopher Browne (416) 646 3304 x124 (land) ---------------------------(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
