pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Christopher Murtagh <christopher.murtagh@mcgill.ca>
To: Janning Vygen <vygen@planwerk6.de>
Cc: pgsql-php@postgresql.org
Subject: Re: How to handle missing pgsql.connect_timeout
Date: Tue, 01 Feb 2005 12:10:32 -0500
Message-ID: <1107277832.12116.1.camel@localhost.localdomain> (raw)
In-Reply-To: <200502011740.48639.vygen@planwerk6.de>
References: <200502010938.17853.vygen@gmx.de>
	<1107263917.11348.10.camel@mafalda.corporateunderground.org>
	<200502011740.48639.vygen@planwerk6.de>

On Tue, 2005-02-01 at 17:40 +0100, Janning Vygen wrote:
> Am Dienstag, 1. Februar 2005 14:18 schrieben Sie:
> > On Tue, 2005-02-01 at 09:38 +0100, Janning Vygen wrote:
> > > Does anybody has any hints to solve this problem?
> >
> >  This is a bit of a non-solution, but it is what worked for us. We
> > simply stopped using pconnect() altogether. This seemed to have solved
> > connection timeouts and delays. Our site gets 500k page hits per day
> > without any problems.
> 
> hm. i didn't get the point. Do you mean you don't use persistent connections 
> just plain pg_connect instead of pg_pconnect?? 

 Exactly. pg_pconnect() is (or was the last time I tried it) broken in
PHP. We were constantly getting connections that wouldn't close, and
sometimes not time out. Ever since we gave up on them, we've had no
problems.

Cheers,

Chris

-- 
Christopher Murtagh
Enterprise Systems Administrator
ISR / Web Communications Group 
McGill University
Montreal, Quebec
Canada

Tel.: (514) 398-3122
Fax:  (514) 398-2017




view thread (8+ messages)  latest in thread

Message-ID: <1107277832.12116.1.camel@localhost.localdomain>
Permalink:  ../1107277832.12116.1.camel@localhost.localdomain/
Also on:    postgresql.org/message-id/1107277832.12116.1.camel@localhost.localdomain

 · 

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: christopher.murtagh@mcgill.ca, vygen@planwerk6.de
  Subject: Re: How to handle missing pgsql.connect_timeout
  In-Reply-To: <1107277832.12116.1.camel@localhost.localdomain>
  References: <200502010938.17853.vygen@gmx.de> <1107263917.11348.10.camel@mafalda.corporateunderground.org> <200502011740.48639.vygen@planwerk6.de> <1107277832.12116.1.camel@localhost.localdomain>

* 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