Christopher Browne <[EMAIL PROTECTED]> writes:
> Clinging to sanity, [EMAIL PROTECTED] (Jón Ragnarsson) mumbled into her beard:
>> Then I read somewhere that Postgres only supports 100 simultaneous
>> connections (default).
> I thought the out-of-the-box default was 32.
Pre-7.4 it was 32; in 7.4 it's 100 (if your kernel settings will allow it).
It's important to point out that both of these are trivial-to-alter
configuration settings, not some kind of hardwired limit. However, the
more backend processes you have, the more RAM you need on the database
server. It's good advice to look into connection pooling instead of
trying to push max_connections up to the moon.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
