Re: slow pg_connect()

From: Chris <dmagick(at)gmail(dot)com>
To: thomas(dot)pundt(at)rp-online(dot)de
Cc: firerox(at)centrum(dot)cz, pgsql-performance(at)postgresql(dot)org
Subject: Re: slow pg_connect()
Date: 2008-03-25 04:18:00
Message-ID: 47E87CF8.9020407@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Matthew T. O'Connor 2008-03-25 04:50:41 Re: Planning hot/live backups?
Previous Message Scott Marlowe 2008-03-25 01:13:28 Re: waiting for harddisk