Re: 2CPU 4GBRAM

peter_e(at)gmx(dot)net (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)