pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: buhrow@lothlorien.nfbcal.org
To: pgsql-interfaces@postgresql.org
Cc: buhrow@lothlorien.nfbcal.org
Subject: Possible memory leak in Postgres V7.0.2/ecpg 2.7.1
Date: Mon, 18 Dec 2000 10:21:47 -0800
Message-ID: <200012181821.KAA27945@lothlorien.nfbcal.org> (raw)

	Hello.  I'm brand new to this list, and fairly new to postgres.
I'm in the midst of writing a database application on top of Postgres
V7.0.2, using ecpg V2.7.1, included with the package.  I find that running
a batch client I wrote leaks memory to the extent that the client bombs out
a quarter of the way through its job.  Thinking it was my code, I traced
through the truss/ktrace output to determine when memory requests were
coming in to the OS from the process in question.  After my
initializations, I discovered that it appears that all subsequent memory
requests come in when the application is executing ecpg code.  Since I'm
not particularly familiar with the innards of the ecpg code, I thought I
would ask if anyone has seen this sort of problem before.  My sql code is
not particularly complicated, but I am using cursors, and it seems that
these allocations happen just before "declare cursor" is executed.  Can
anyone help shed light on what might be going on, and how I might fix it?
I can provide traces if that would help, as well as any debugging
statements, if someone can tell me how to turn them on.
	Many thanks in advance.
-Brian





view thread (4+ messages)  latest in thread

Message-ID: <200012181821.KAA27945@lothlorien.nfbcal.org>
Permalink:  ../200012181821.KAA27945@lothlorien.nfbcal.org/
Also on:    postgresql.org/message-id/200012181821.KAA27945@lothlorien.nfbcal.org

 · 

reply

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-interfaces@postgresql.org
  Cc: buhrow@lothlorien.nfbcal.org
  Subject: Re: Possible memory leak in Postgres V7.0.2/ecpg 2.7.1
  In-Reply-To: <200012181821.KAA27945@lothlorien.nfbcal.org>

* 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