Thread: pgsql and threads don't match

I'm a Linux developer that are making a huge server, and i'm trying out
databases.
Are the postgres librarys not thread-safe?
If not, when will it be?

Sincerly Magnus Näslund

Magnus Näslund wrote:

> I'm a Linux developer that are making a huge server, and i'm trying out
> databases.
> Are the postgres librarys not thread-safe?
> If not, when will it be?

The Postgres backend is single-threaded software. The client stuff is
probably thread-safe, and both frontend and backend work with thread-safe
libraries. Clients can open multiple connections to backends, so I would
think that you could do so from multiple threads. You might need to take a
mutex on the connection-opening step; not sure about that. Also, there is
a separate process per backend connection, so multiple simultaneous
connections are allowed.

Good luck.

                                                             - Tom

On Fri, 13 Feb 1998, Magnus Nslund wrote:

> I'm a Linux developer that are making a huge server, and i'm trying out
> databases.
> Are the postgres librarys not thread-safe?
> If not, when will it be?

I'm assuming you mean the C libraries?

I can't say about them, but the Java/JDBC is _not_ thread safe - yet. It's
one of the 4 main things to work on once 6.3 is released.

--
Peter T Mount  petermount@earthling.net or pmount@maidast.demon.co.uk
Main Homepage: http://www.demon.co.uk/finder
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter@maidstone.gov.uk