apache/php eats too much memory!

[Anon]

Hi!
I'm running mod php 4.04pl1 on apache 1.3.9 and the consommation of apache processes is too disconcerting for me!
Each apache process uses ~25 Mo of rss mem (and ~3,5 of shared memory)!
So I reduce my MaxRequestPerChild to 10, and the processes don't seem to overtake 7 Mo of RSS from now. It's a temporary solution and I'd like to understand this strange phenomenon.. Could it be a memory leak in mod_php or in his dependancies?
(Notes that my php script use persistent PostgreSQL connection and that Apache is configured with KeepAlive on..)
Anyone has an idea?

[kparker]

use persistent PostgreSQL connections

There's your problem! These are known to cause problems, and are
best avoided. Substitute a plain pg_connect() and things will work
fine.

[Anon]

well i am also facing the same problem and i am using pg_connect only.but the apache is taking too much system resources.
pls suggest wht shd i do.

rgds.
Himanshu