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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
