Re: Pooling Connections with libpq

* Shaw Terwilliger <sterwill@sourcegear.com> [010222 14:42] wrote:
> In my application, I'm doing my own pooling of connections to PostgreSQL
> for sharing between threads.  I'm using libpq for all database access.
> Only one thread at a time can use a connection.
>
> Besides freeing all query results, do I have to do anything else to ensure
> my application (through libpq) and the backends don't leak RAM after long
> periods of use?  I'm not using temporary tables, I'm only doing SELECTs on
> these connections, reading, and then freeing the results.

As a general safety precaution I would close a connection after a
timeout or N uses.

--
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]