Keeping processes open for re-use
От | Hilary Forbes |
---|---|
Тема | Keeping processes open for re-use |
Дата | |
Msg-id | 5.1.0.14.0.20061109123348.0418fbb8@mailserver.dmr.co.uk обсуждение исходный текст |
Ответы |
Re: Keeping processes open for re-use
Re: Keeping processes open for re-use |
Список | 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 по дате отправления: