...or so it seems: I configured our webserver to not use persistant
connections et voilà - no more 200+MB backends!
I knew there was supposed to be some bug in PHP, so users of Apache/PHP
are discouraged to use persistant connections. As we are using
ColdFusion/IIS on Win2k Server with ODBC I never suspected that there
should be a similar issue with my configuration. Now we just switched
off the persistant connection option (which was a true winner for our
Oracle DB, performance-wise) and noticed the lack of these
giant-backends we had learned to fear and endure before.
Now there's still the odd 250MB backend lingering around for some time,
but it's not four or five of them any more, wich is a big gain when
there's 250MB swap around more often than not.
Are there any known issues concerning persistant connections apart from
the pgpconnect-thingy with PHP? Is anyone running the same combination
of *nix/Postgres+IIS/ColdFusion?
Regards,
Markus