Keeping processes open for re-use - Mailing list pgsql-performance

From Hilary Forbes
Subject Keeping processes open for re-use
Date
Msg-id 5.1.0.14.0.20061109123348.0418fbb8@mailserver.dmr.co.uk
Whole thread Raw
Responses Re: Keeping processes open for re-use  (Csaba Nagy <nagy@ecircle-ag.com>)
Re: Keeping processes open for re-use  (imad <immaad@gmail.com>)
List pgsql-performance
Dear All<br /><br /> Looking at the processes running on our server, it appears that each time a web server program
makesa call to the database server, we start a new process on the database server which obviously has a start up cost.
InApache, for example, you can say at start up time,that you want the machine to reserve eg 8 processes and keep them
openat all times so you don't have this overhead until you exceed this minimum number. Is there a way that we can
achievethis in Postgres? We have a situation whereby we have lots of web based users doing short quick queries and
obviouslythe start up time for a process must add to their perceived response time.<br /><br /> Thanks<br /> Hilary<br
/><br/><br /><br /><p> Hilary Forbes<br /> DMR Limited (UK registration 01134804) <br /> A DMR Information and
TechnologyGroup company (<a eudora="autourl" href="http://www.dmr.co.uk/"><font
color="#0000FF"><u>www.dmr.co.uk</u></font></a>)<br /> Direct tel 01689 889950 Fax 01689 860330 <br /> DMR is a UK
registeredtrade mark of DMR Limited<br /> ********************************************************** 

pgsql-performance by date:

Previous
From: "Luke Lonergan"
Date:
Subject: Re: Easy read-heavy benchmark kicking around?
Next
From: Csaba Nagy
Date:
Subject: Re: Keeping processes open for re-use