Re: question on backends

if i put debug_level=1 i get for one connect and several inserts on backend
die after each insert
----- Original Message -----
From: "Hannu Krosing" <hannu@tm.ee>
To: "Luis Alberto Amigo Navarro" <lamigo@atc.unican.es>
Cc: <pgsql-hackers@postgresql.org>
Sent: Monday, July 29, 2002 8:42 PM
Subject: Re: [HACKERS] question on backends


> On Mon, 2002-07-29 at 11:32, Luis Alberto Amigo Navarro wrote:
> > Hi all
> > As I understand every time there is a request to postgres a new backend
> > is made, and when the request is finished, even if the connection is
> > already active the backend dies.
>
> I think you have misunderstood it. A new backend is forked only when a
> new connection is made, not for every transaction.
>
> There may be some frontends that do make a new connection for each http
> request or such, but most of them allow for persistent connections,
> either as an option or by default.
>
> > I wonder if is there any parameter
> > that allow backends to remain beyond a transaction. Creating a new
> > backend every time a transaction is made means forking the code and
> > reallocating sort_memory.
>
> ------------------
> Hannu
>
>