DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding;
	b=NOtkJ62QRiRQIn5PqO3dPsY7QmKCxJaBDF+pYEWoQUHCYReKOIeFoxf2CpocKdGnBARf8/B967C3HJaMaoEmBiM0IwnxVdq5RpBvKs84jzovHN+qXLYofm3ZPbbdyTAbYWgaxIyRgkfWzp/IXDzmRxbV1csEWASiUhY+QFY+m38=
Message-ID: <47E87CF8.9020407@gmail.com>
Date: Tue, 25 Mar 2008 15:18:00 +1100
From: Chris <dmagick@gmail.com>
User-Agent: Thunderbird 2.0.0.12 (Windows/20080213)
MIME-Version: 1.0
To: thomas.pundt@rp-online.de
CC: firerox@centrum.cz, pgsql-performance@postgresql.org
Subject: Re: slow pg_connect()
References: <200803240840.8128@centrum.cz> <47E7A10F.5060805@rp-online.de>
In-Reply-To: <47E7A10F.5060805@rp-online.de>
Content-Type: text/plain; charset=windows-1250; format=flowed
Content-Transfer-Encoding: 7bit


> * Read about configuring and using persistent database connections
>   (http://www.php.net/manual/en/function.pg-pconnect.php) with PHP

Though make sure you understand the ramifications of using persistent 
connections. You can quickly exhaust your connections by using this and 
also cause other issues for your server.

If you do this you'll probably have to adjust postgres to allow more 
connections, which usually means lowering the amount of shared memory 
each connection can use which can also cause performance issues.

I'd probably use pgpool-II and have it handle the connection stuff for 
you rather than doing it through php.

-- 
Postgresql & php tutorials
http://www.designmagick.com/