Child process procedures - Mailing list pgsql-performance

From Thrasher
Subject Child process procedures
Date
Msg-id 3DE4DC24.3020108@fibers.upc.es
Whole thread Raw
List pgsql-performance
Hi all,

I have developed a system that is composed of 10 separate running
processes. Each of the processes opens a connection to postgres with the
C interface.

Whenever any process has to process any query, it should fork and create
a new independent process (not thread). How does the database connection
is kept?

In other words, if I fork a process that have an opened postgres
connection, does its children inherit that connection, and can I use
them as is, closing them at the end, or do I have to open a new
connection foreach children process ?

Thanks in advance,

Thrasher


pgsql-performance by date:

Previous
From: Jim Beckstrom
Date:
Subject: Re: [HACKERS] Realtime VACUUM, was: performance of insert/delete/update
Next
From: "Dave Page"
Date:
Subject: Re: [HACKERS] Realtime VACUUM, was: performance of insert/delete/update