From: Alvaro Herrera <alvherre@commandprompt.com>
To: Robert Gruszka <rgruszka@power.com.pl>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: multiple threads using one connection
Date: Tue, 28 Feb 2006 12:09:50 -0300
Message-ID: <20060228150950.GC6343@surnet.cl> (raw)
In-Reply-To: <440443A2.5080907@power.com.pl>
References: <440443A2.5080907@power.com.pl>
Robert Gruszka wrote:
> Hi,
>
> I have multi-thread application written in Ada which uses APQ. All
> threads use the same connection (can't afford one connection per
> thread). I compiled libpq with --enable-thread-safty option.
> When two threads try to execute a query at the same time one of them is
> blocked and even when the other one finishes it is not unblocked.
The libpq API is not really intended to be used by multiple threads
simultaneously (unless you make sure only one thread is submitting a
query and waiting for the result at any time).
The --enable-thread-safety flag is merely to ensure that the calls to
other libraries (Kerberos, etc) are handled in a thread-safe manner. It
doesn't have any effect on the thread safety of the libpq API itself.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: alvherre@commandprompt.com, rgruszka@power.com.pl
Subject: Re: multiple threads using one connection
In-Reply-To: <20060228150950.GC6343@surnet.cl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox