Re: FW: URGENT: pgsql on the web server - memory problems.... - Mailing list pgsql-general

From Gunnar R|nning
Subject Re: FW: URGENT: pgsql on the web server - memory problems....
Date
Msg-id x6zokjfm2y.fsf@thor.candleweb.no
Whole thread Raw
In response to FW: URGENT: pgsql on the web server - memory problems....  ("Nikolay Mijaylov" <pg@nmmm.nu>)
Responses RE: FW: URGENT: pgsql on the web server - memory problems....  ("Nikolay Mijaylov" <nmmm@nmmm.nu>)
List pgsql-general
"Nikolay Mijaylov" <pg@nmmm.nu> writes:

> The problem is that PHP is auto killing after a while (1-2 min), but the pos
> tgres backend process stay (and works about 2 or many more hours). Soon all
> Linux is filled with 64 postgres processes, free memory is 0 and Linux, free
> ze :)
>

The postgres backend processes should die when the connections are
closed. Are you sure that the process that runs PHP doesn't keep the
connections open ? You should check open ports using netstat -a and maybe
go on using lsof to check the client processes.

regards,

    Gunnar

pgsql-general by date:

Previous
From: Michael Ansley
Date:
Subject: Object syntax
Next
From: Matthew
Date:
Subject: RE: FW: URGENT: pgsql on the web server - memory proble ms....