Skip site navigation (1) Skip section navigation (2)

Re: memory usage

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: memory usage
Date: 2000-09-28 04:12:29
Message-ID: web-1093339@davinci.ethosmedia.com (view raw or flat)
Thread:
Lists: pgsql-sql
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

In response to

Responses

pgsql-sql by date

Next:From: Carolyn WongDate: 2000-09-28 04:39:35
Subject: memory usage
Previous:From: Jie LiangDate: 2000-09-27 19:55:40
Subject: Re: copying/moving from one table to another

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group