Memory problems when using savepoints - Mailing list pgsql-novice

From Tim Baumgartner
Subject Memory problems when using savepoints
Date
Msg-id 4457730B.2090001@gmx.de
Whole thread Raw
List pgsql-novice
Hi!

I am using PostgreSQL 8.1. In a long import transaction, I am using a
lot of SavePoints (JDBC). I noticed that the memory usage of the server
process is constantly increasing in this situation (after less then 5
minutes, it's already above 200 MB). When I don't use the savepoints,
it's memory usage remains almost constant over time (~17MB). Of course,
I call Connection#releaseSavepoint(oldSavepoint) before setting the next
one. The problem is the same for me on Win 2000 and on Linux.
Does anybody know this problem?

Thanks
Tim


pgsql-novice by date:

Previous
From: "Robert Wimmer"
Date:
Subject: Re: error handling
Next
From: "Tomeh, Husam"
Date:
Subject: Re: stress tests problems