postgres process grows. - Mailing list pgsql-interfaces

From Matthew Liste
Subject postgres process grows.
Date
Msg-id 36030EF8.4CBE1A09@baynetworks.com
Whole thread Raw
List pgsql-interfaces
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)

pgsql-interfaces by date:

Previous
From: Constantin Teodorescu
Date:
Subject: PgAccess 0.90 new version released - user input query parameters available
Next
From: Stephen Davies
Date:
Subject: SQLPrimaryKeys