durusmail: quixote-users: reusing connections, SCGI and PostgreSQL max_connection limit
reusing connections, SCGI and PostgreSQL max_connection limit
2005-01-24
reusing connections, SCGI and PostgreSQL max_connection limit
Ksenia Marasanova
2005-01-26
> Most of those connections won't get used & postgresql can easily handle
> a lot of connections; in conjunction with my simple Linda tuple space
> implementation, the Quixote-based app I run has about 30 connections per
> app instance.  Wasteful but not worth optimizing so far ;).
>
> One thing to watch out for is that Postgres works on a process model,
> so each connection means a new backend... you might need extra swap
> space.
>
> Incidentally, I use psycopg, which may lead to even more connection
> "waste" as it maintains a pool of connections itself.

Yes, mee too.
Glad to hear that "wasting" of the connections isn't that bad :)

Thanks,
--
Ksenia

reply