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



Fri, 13 Feb 1998 17:16:31 +0100
"Magnus N���slund" <Magnus@Graphicomp.Se>
pgsql and threads don't match
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


Fri, 13 Feb 1998 17:02:14 +0000
"Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
Re: [HACKERS] pgsql and threads don't match
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


Sat, 14 Feb 1998 10:54:29 +0000 (GMT)
Peter T Mount <psqlhack@maidast.demon.co.uk>
Re: [HACKERS] pgsql and threads don't match