Re: Pooling Connections with libpq

* Shaw Terwilliger <sterwill(at)sourcegear(dot)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(at)wintelcom(dot)net|alfred(at)freebsd(dot)org]