pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: memory usage
4+ messages / 3 participants
[nested] [flat]
* memory usage
@ 2000-09-28 04:39 Carolyn Wong <carolyn@kss.net.au>
2000-09-28 04:12 ` Re: memory usage Josh Berkus <josh@agliodbs.com>
2000-09-28 15:00 ` Re: memory usage John Hasler <john@dhh.gt.org>
0 siblings, 2 replies; 4+ messages in thread
From: Carolyn Wong @ 2000-09-28 04:39 UTC (permalink / raw)
To: pgsql-sql; pgsql-interfaces@postgresql.org <pgsql-interfaces@postgresql.org>
I have a Borland C++ program (running on NT server) which connects to
PostgresSQL (V6.5) via ODBC (V6.5). The program reads data file and
updates database at regular intervals. The program has close all
connections when execution finishes.
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.
Could the problem comes from front-end program, the ODBC, the database
or any other source? Any idea?
The current solution is to reboot the linux server every now and then to
fix this problem. Of course this is a short term solution and I'm
looking for a permanent solution.
Thanks.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: memory usage
2000-09-28 04:39 memory usage Carolyn Wong <carolyn@kss.net.au>
@ 2000-09-28 04:12 ` Josh Berkus <josh@agliodbs.com>
1 sibling, 0 replies; 4+ messages in thread
From: Josh Berkus @ 2000-09-28 04:12 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: memory usage
2000-09-28 04:39 memory usage Carolyn Wong <carolyn@kss.net.au>
@ 2000-09-28 15:00 ` John Hasler <john@dhh.gt.org>
2000-09-29 00:19 ` Re: memory usage Carolyn Wong <carolyn@kss.net.au>
1 sibling, 1 reply; 4+ messages in thread
From: John Hasler @ 2000-09-28 15:00 UTC (permalink / raw)
To: pgsql-sql; pgsql-interfaces@postgresql.org <pgsql-interfaces@postgresql.org>
Carolyn Wong writes:
> 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.
Are you quite certain that this is actually what is happening? Linux
memory usage can be confusing.
--
John Hasler
john@dhh.gt.org (John Hasler)
Dancing Horse Hill
Elmwood, WI
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: memory usage
2000-09-28 04:39 memory usage Carolyn Wong <carolyn@kss.net.au>
2000-09-28 15:00 ` Re: memory usage John Hasler <john@dhh.gt.org>
@ 2000-09-29 00:19 ` Carolyn Wong <carolyn@kss.net.au>
0 siblings, 0 replies; 4+ messages in thread
From: Carolyn Wong @ 2000-09-29 00:19 UTC (permalink / raw)
To: John Hasler <john@dhh.gt.org>; +Cc: pgsql-sql; pgsql-interfaces@postgresql.org <pgsql-interfaces@postgresql.org>
John Hasler wrote:
>
> Carolyn Wong writes:
> > 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.
>
> Are you quite certain that this is actually what is happening? Linux
> memory usage can be confusing.
I run 'top' to see cpu usage when running the program. The 'postmaster'
command seems to stay after my program terminates. Because the program
runs every 10 minutes, when it restarts, the mem usage for the same
command increases.
> --
> John Hasler
> john@dhh.gt.org (John Hasler)
> Dancing Horse Hill
> Elmwood, WI
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2000-09-29 00:19 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-09-28 04:39 memory usage Carolyn Wong <carolyn@kss.net.au>
2000-09-28 04:12 ` Josh Berkus <josh@agliodbs.com>
2000-09-28 15:00 ` John Hasler <john@dhh.gt.org>
2000-09-29 00:19 ` Carolyn Wong <carolyn@kss.net.au>
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