pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Chadwick Rolfs <cmr@shell.gis.net>
To: Chris Ruprecht <chrup999@yahoo.com>
Cc: PostGreSQL PHP Group <pgsql-php@postgresql.org>
Subject: Re: pg_pconnect - ??
Date: Mon, 28 Jan 2002 16:07:17 -0500 (EST)
Message-ID: <Pine.SOL.3.96.1020128160529.25035E-100000@shell.gis.net> (raw)
In-Reply-To: <p05101218b87b6220cfa3@[192.168.0.6]>

Sorry, I guess you can disregard most of my reply:)

But a functiont that checks for connections and makes on only if one isn't
already there is still good idea, if you are making many queries in a
small amount of time.

Are you making many queries at once, or the same one many times, or
different ones quickly?

On Mon, 28 Jan 2002, Chris Ruprecht wrote:

> Ok, so from what I see on here, pg_pconnect doesn't have any 
> advantages over pg_connect in my situation. I have the web server 
> running on the same machine as the database server and yes, I have 
> allocated 16384 shared buffers (at 8 KB each, this is 128 MB of 
> shared memory). I have not noticed any connect overhead when opening 
> a web page which connects to the database (99% of them do), the 
> connection is instantaneously, so I guess, I don't need to do 
> anything here.
> I was under the impression, that a persistent connection would open 
> one and only one process which then will be used all the time without 
> creating more child processes which keep lingering about. I guess, I 
> was wrong here ...
> 
> Best regards,
> Chris
> -- 
> Chris Ruprecht
> Network grunt and bit pusher extraordinaíre
> 
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> 

Chadwick Rolfs - cmr@gis.net
Cleveland State University - Student
Music Major - The Holden Arboretum Volunteer
Computer Programmer - Student Employee
--*I finally found powdered water;
I just can't figure out what to add to it*--




view thread (26+ messages)  latest in thread

Message-ID: <Pine.SOL.3.96.1020128160529.25035E-100000@shell.gis.net>
Permalink:  ../Pine.SOL.3.96.1020128160529.25035E-100000@shell.gis.net/
Also on:    postgresql.org/message-id/Pine.SOL.3.96.1020128160529.25035E-100000@shell.gis.net

 · 

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-php@postgresql.org
  Cc: cmr@shell.gis.net, chrup999@yahoo.com
  Subject: Re: pg_pconnect - ??
  In-Reply-To: <Pine.SOL.3.96.1020128160529.25035E-100000@shell.gis.net>
  References: <p05101218b87b6220cfa3@[192.168.0.6]> <Pine.SOL.3.96.1020128160529.25035E-100000@shell.gis.net>

* 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