Re: Connection Pooling directly on Postgres Server

Hi,

Denis Gasparin wrote:
> Why not to implement a connection pooling server side as apache for
> example does?

This has certainly been discussed before.

IIRC the real argument against that was, that fork() isn't the most
expensive thing to do anymore. And Postgres does lots of other stuff
after accept(), namely connecting to a certain database, authenticating
the user, etc..

If you still want to optimize that, you'd end up having n spare backends
*per database*. I do that in Postgres-R - not for connection pooling,
but for application of remote transactions.

Regards

Markus