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" <[EMAIL PROTECTED]> To: "Luis Alberto Amigo Navarro" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> 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 > > ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly