Keeping processes open for re-use

From: Hilary Forbes <hforbes(at)dmr(dot)co(dot)uk>
To: pgsql-performance(at)postgresql(dot)org
Subject: Keeping processes open for re-use
Date: 2006-11-09 12:35:00
Message-ID: 5.1.0.14.0.20061109123348.0418fbb8@mailserver.dmr.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

<html>
Dear All<br><br>
Looking at the processes running on our server, it appears that each time
a web server program makes a call to the database server, we start a new
process on the database server which obviously has a start up cost. In
Apache, for example, you can say at start up time,that you want the
machine to reserve eg 8 processes and keep them open at all times so you
don't have this overhead until you exceed this minimum number. Is there a
way that we can achieve this in Postgres? We have a situation whereby we
have lots of web based users doing short quick queries and obviously the
start up time for a process must add to their perceived response
time.<br><br>
Thanks<br>
Hilary<br><br>
<br><br>
<x-sigsep><p></x-sigsep>
Hilary Forbes<br>
DMR Limited (UK registration 01134804) <br>
A DMR Information and Technology Group company
(<a href="http://www.dmr.co.uk/" eudora="autourl"><font color="#0000FF"><u>www.dmr.co.uk</a></u></font>)
<br>
Direct tel 01689 889950 Fax 01689 860330 <br>
DMR is a UK registered trade mark of DMR Limited<br>
**********************************************************</html>

Attachment Content-Type Size
unknown_filename text/html 1.1 KB

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Csaba Nagy 2006-11-09 12:56:04 Re: Keeping processes open for re-use
Previous Message Luke Lonergan 2006-11-08 19:32:50 Re: Easy read-heavy benchmark kicking around?