From: Matthew Liste <matthew@BayNetworks.COM>
To: pgsql-interfaces@postgresql.org
Subject: postgres process grows.
Date: Fri, 18 Sep 1998 21:55:04 -0400
Message-ID: <36030EF8.4CBE1A09@baynetworks.com> (raw)
I'm accessing a database using JDBC, I keep a socket open for a long
time and for multiple queries. My Java code for a query typically
looks like:
Statement sta = con.createStatement();
sta.executeQuery( "DELETE FROM TABLE" );
For some reason, the postgres daemon that gets forked on the DB
server (Solaris 2.6, postgresql 6.3.2) keeps growing for each query
that I execute, until it eats up all memory. Is there something I'm
doing wrong in my queries, or is there a patch for this?
Thanks for any help,
-Matthew (matthew@baynetworks.com)
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: matthew@BayNetworks.COM
Subject: Re: postgres process grows.
In-Reply-To: <36030EF8.4CBE1A09@baynetworks.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