Re: postmaster processes - Mailing list pgsql-general

From Andy Harrison
Subject Re: postmaster processes
Date
Msg-id XFMail.20030904135951.ah11@mlz.us
Whole thread Raw
In response to Re: postmaster processes  (Doug McNaught <doug@mcnaught.org>)
List 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-----

pgsql-general by date:

Previous
From: "Andrew J. Kopciuch"
Date:
Subject: Re: tsearch2 and unexpected exists
Next
From: Andreas Muck
Date:
Subject: Re: More than 1024 connections from the same c-backend