question on backends - Mailing list pgsql-hackers

From Luis Alberto Amigo Navarro
Subject question on backends
Date
Msg-id 006e01c236e2$e6152750$cab990c1@atc.unican.es
Whole thread Raw
Responses Re: question on backends
List pgsql-hackers
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 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. Although it is not a high resource usage, on short transactions as OLTPs it is a relevant work time, I think it would be interesting that a predefined number of backends were allowed to remain active beyond the transaction.
Thanks and Regards

pgsql-hackers by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Re: [GENERAL] Stats Collector
Next
From: Dave Cramer
Date:
Subject: Re: JDBC does not compile