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