Re: Lookup Error with PostgreSQL backened in SigningTable

From: Graham Murray <>
Date: Tue, 14 Sep 2010 20:53:01 +0100

"Murray S. Kucherawy" <> writes:

> What do other applications do to overcome this?
> Do they set up a pool of query handles and just use a free one, or do
> they mutex-protect one shared by all threads, or something else? I
> have a patch to do the latter ready. Anything more complicated than
> that will probably have to wait for the next major release.

What I do, when using the libpq interface, is for each thread to open
its own connection using pthread_getspecific() and pthread_setspecific()
to associate the connection handle with each thread.
Received on Tue Sep 14 2010 - 19:53:12 PST

This archive was generated by hypermail 2.3.0 : Mon Oct 29 2012 - 23:19:48 PST