* 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]