From: Josh Berkus <josh@agliodbs.com>
To: pgsql-sql@postgresql.org
Subject: Re: memory usage
Date: Wed, 27 Sep 2000 21:12:29 -0700
Message-ID: <web-1093339@davinci.ethosmedia.com> (raw)
In-Reply-To: <39D2CB86.579C8FE5@kss.net.au>
Ms. Wong,
> This program seems to use a lot of the memory on the
> linux server, and
> the memory doesn't seem to be released at the end of
> execution. The same
> thing occurs when I try to connect to the database from
> MS Access via
> ODBC.
It's been my experience that Win32 ODBC does not drop
connections until the database client is closed (e.g. MS
Access is shut down). For example, I have a program that
connects MS Access through ODBC to a remote MySQL database
via an SSH tunnel; the tunnel does not close until I shut
down MS Access even if I kill the parent shell. ODBC keeps
it alive.
If, howoever, the connections (and their memory usage) are
persisting after termination of the client application, I
would look to your network environment for answers. It
could be that you are routing through a switch that is, for
some reason, keeping the client-server connection open after
data has stopped transmitting. The last place I'd look
would be the linux server; my experience is that Linux is
worlds better at managing connections than Win32 or cheap
Ethernet switches.
Good Luck!
-Josh
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: josh@agliodbs.com
Subject: Re: memory usage
In-Reply-To: <web-1093339@davinci.ethosmedia.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox