pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Janning Vygen <vygen@planwerk6.de>
To: Christopher Murtagh <christopher.murtagh@mcgill.ca>
Cc: pgsql-php@postgresql.org
Subject: Re: How to handle missing pgsql.connect_timeout
Date: Wed, 2 Feb 2005 09:49:20 +0100
Message-ID: <200502020949.21251.vygen@planwerk6.de> (raw)
In-Reply-To: <1107277832.12116.1.camel@localhost.localdomain>
References: <200502010938.17853.vygen@gmx.de>
	<200502011740.48639.vygen@planwerk6.de>
	<1107277832.12116.1.camel@localhost.localdomain>

Am Dienstag, 1. Februar 2005 18:10 schrieb Christopher Murtagh:
> 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. 

It's not broken anymore! And it speeds up your website. 

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

Thats not exactly my problem. I just want to have say

20 MaxClients to wait for http Connections
but only 5 possible DB Connections

I http server no. 6 tries to connect i want pg_pconnect (or pg_connect; that 
doesn't matter) to wait maximal 1 second and then return an error.

At the moment it waits "forever" (until max_execution_time i guess) and you 
have no chance to show an error message like: DB is overloaded, please try 
again.

php_pgsql module doesn't have a directive like mysql which is 
mysql_connection_timeout.

i tried pgpool but it doesn't have a timeout value for establishing a 
connection.

That's my problem. My DB is overloaded once a week to a special peek time and 
i can't afford more hardware. I just want a simple and kind error message.

kind regards
janning



view thread (8+ messages)  latest in thread

Message-ID: <200502020949.21251.vygen@planwerk6.de>
Permalink:  ../200502020949.21251.vygen@planwerk6.de/
Also on:    postgresql.org/message-id/200502020949.21251.vygen@planwerk6.de

 · 

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

* 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