Thread: Memory problems when using savepoints

Memory problems when using savepoints

From
Tim Baumgartner
Date:
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