Re: slow pg_connect() - Mailing list pgsql-performance

From Chris
Subject Re: slow pg_connect()
Date
Msg-id 47E87CF8.9020407@gmail.com
Whole thread Raw
In response to Re: slow pg_connect()  (Thomas Pundt <mlists@rp-online.de>)
List 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/

pgsql-performance by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: waiting for harddisk
Next
From: "Matthew T. O'Connor"
Date:
Subject: Re: Planning hot/live backups?