Re: slow pg_connect()

Поиск
Список
Период
Сортировка
От Chris
Тема Re: slow pg_connect()
Дата
Msg-id 47E87CF8.9020407@gmail.com
обсуждение исходный текст
Ответ на Re: slow pg_connect()  (Thomas Pundt <mlists@rp-online.de>)
Список 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 по дате отправления:

Предыдущее
От: "Scott Marlowe"
Дата:
Сообщение: Re: waiting for harddisk
Следующее
От: "Matthew T. O'Connor"
Дата:
Сообщение: Re: Planning hot/live backups?