Thread

  1. pgsql and threads don't match

    Magnus Nslund <magnus@graphicomp.se> — 1998-02-13T16:16:31Z

    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
    
    
    
    
  2. Re: [HACKERS] pgsql and threads don't match

    Thomas Lockhart <lockhart@alumni.caltech.edu> — 1998-02-13T17:02:14Z

    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
    
    
    
  3. Re: [HACKERS] pgsql and threads don't match

    Peter T Mount <psqlhack@maidast.demon.co.uk> — 1998-02-14T10:54:29Z

    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