Re: postmaster processes

From: Andy Harrison <ah11(at)mlz(dot)us>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: postmaster processes
Date: 2003-09-04 17:59:51
Message-ID: XFMail.20030904135951.ah11@mlz.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

-----BEGIN PGP SIGNED MESSAGE-----

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
On 04-Sep-2003, Doug McNaught wrote message "Re: [GENERAL] postmaster processes"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> No, it doesn't. If a PG backend is hanging around, it means an
> application is keeping it open. Most likely the app has a connection
> pooling library that hangs onto connections rather than incur the
> overhead of creating new ones for every request.

Thanx! This led me in the right direction, the php.ini defaults:

[PostgresSQL]
; Allow or prevent persistent links.
pgsql.allow_persistent = On
; Detect broken persistent links always with pg_pconnect().
; Auto reset feature requires a little overheads.
pgsql.auto_reset_persistent = Off
; Maximum number of persistent links. -1 means no limit.
pgsql.max_persistent = -1
; Maximum number of links (persistent+non persistent). -1 means no limit.
pgsql.max_links = -1

~~
Andy Harrison
(full headers for details)

-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.8

iQCVAwUBP1d9lVPEkLgodAWVAQFCLQP/fkUxdh+c6R4NKz3hWvGSBjL7pp+Dsuo/
5cq94c3hgqGdOKAo5R90JAjSpwt5xWovXbhDeYw/MM8UM0Ku6mTbOC2YEjGEkz5S
fkfPLpHRd9ufHeKOUVyUfp2C0rwFhefLPx5MeXz1hTyHZzHzlxnhwKMVOe4Zlni3
L6S4BmOP1V4=
=bE+l
-----END PGP SIGNATURE-----

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2003-09-04 18:04:44 Re: is it possible to do this? have a subselect that
Previous Message Alvaro Herrera Munoz 2003-09-04 17:08:23 Re: French translation