[Pgpool-general] Pgpool-general] problem pgpool shutdown

Felix J. Ogris fjo-lists at ogris.de
Fri Nov 9 23:47:22 UTC 2007


Hi,

>   Can many Client-pgpool-connection work together over
>   one pgpool-postgres-connection only?

no, pgpool can not multiplex connections since PostgreSQL itself doesn't
support multiple asynchronous queries per connection.

> exim. Each incoming mail generate one exim-prozess.
> Each exim-prozess create one db-connection.
> 
> Worstcase: up top 3000  parallel connections are possible.
> More as 1000  postgres-connections are not possible. (oom-killer)

As long as your smtpd doesn't write anything into the db, bdb/cdb/gdbm files
are much more efficient.

Felix




More information about the Pgpool-general mailing list