pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: imad <immaad@gmail.com>
To: Hilary Forbes <hforbes@dmr.co.uk>
Cc: pgsql-performance@postgresql.org
Subject: Re: Keeping processes open for re-use
Date: Thu, 9 Nov 2006 22:55:41 +0500
Message-ID: <1f30b80c0611090955h567bd4bboa3cfc60ec7bd8dd9@mail.gmail.com> (raw)
In-Reply-To: <5.1.0.14.0.20061109123348.0418fbb8@mailserver.dmr.co.uk>
References: <5.1.0.14.0.20061109123348.0418fbb8@mailserver.dmr.co.uk>

Yes. This is connection pooling. You can find a lot of examples from
the internet on connection pooling, rather source codes. Also keep in
mind that connection pools can be maintained on the application as
well as the database server side. Check which one suits you.


--Imad
www.EnterpriseDB.com


On 11/9/06, Hilary Forbes <hforbes@dmr.co.uk> wrote:
>  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
>
>
>
>
>
>  Hilary Forbes
>  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
>  **********************************************************



view thread (7+ messages)  latest in thread

Message-ID: <1f30b80c0611090955h567bd4bboa3cfc60ec7bd8dd9@mail.gmail.com>
Permalink:  ../1f30b80c0611090955h567bd4bboa3cfc60ec7bd8dd9@mail.gmail.com/
Also on:    postgresql.org/message-id/1f30b80c0611090955h567bd4bboa3cfc60ec7bd8dd9@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: immaad@gmail.com, hforbes@dmr.co.uk
  Subject: Re: Keeping processes open for re-use
  In-Reply-To: <1f30b80c0611090955h567bd4bboa3cfc60ec7bd8dd9@mail.gmail.com>
  References: <5.1.0.14.0.20061109123348.0418fbb8@mailserver.dmr.co.uk> <1f30b80c0611090955h567bd4bboa3cfc60ec7bd8dd9@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox