Re: 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