Skip site navigation (1)
Skip section navigation (2)
Dear All
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.
Thanks
Hilary
DMR Limited (UK registration 01134804)
A DMR Information and Technology Group company (www.dmr.co.uk)
Direct tel 01689 889950 Fax 01689 860330
DMR is a UK registered trade mark of DMR Limited
**********************************************************
Peripheral Links
Header And Logo
|
Site Navigation
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: Thu, 09 Nov 2006 12:35:00 +0000
- Message-id: <5(dot)1(dot)0(dot)14(dot)0(dot)20061109123348(dot)0418fbb8(at)mailserver(dot)dmr(dot)co(dot)uk>
Dear All
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.
Thanks
Hilary
DMR Limited (UK registration 01134804)
A DMR Information and Technology Group company (www.dmr.co.uk)
Direct tel 01689 889950 Fax 01689 860330
DMR is a UK registered trade mark of DMR Limited
**********************************************************
- Follow-Ups:
- Re: Keeping processes open for re-use
- From: imad
- Re: Keeping processes open for re-use
- From: Csaba Nagy
- Re: Keeping processes open for re-use
- Prev by Date: Re: Easy read-heavy benchmark kicking around?
- Next by Date: Re: Keeping processes open for re-use
- Previous by thread: Re: Which OS provides the _fastest_ PostgreSQL performance?
- Next by thread: Re: Keeping processes open for re-use
- Indexes: