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*--
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