One source of constant annoyance identified

From: "Markus Wollny" <Markus(dot)Wollny(at)computec(dot)de>
To: <pgsql-general(at)postgresql(dot)org>
Subject: One source of constant annoyance identified
Date: 2002-06-27 12:27:47
Message-ID: 2266D0630E43BB4290742247C8910575014CE2AA@dozer.computec.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

...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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message wsheldah 2002-06-27 12:34:36 Re: Large Objects
Previous Message Fouad Fezzi 2002-06-27 10:55:04 encoding problem