Re: Lookup Error with PostgreSQL backened in SigningTable

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

"Murray S. Kucherawy" <msk_at_blackops.org> 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.2.0+W3C-0.50 : Tue Sep 14 2010 - 20:50:00 PST