Memory problems when using savepoints

From: Tim Baumgartner <jongleur0815(at)gmx(dot)de>
To: pgsql-novice(at)postgresql(dot)org
Subject: Memory problems when using savepoints
Date: 2006-05-02 14:56:11
Message-ID: 4457730B.2090001@gmx.de
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-novice by date

  From Date Subject
Next Message Tomeh, Husam 2006-05-02 15:02:56 Re: stress tests problems
Previous Message Roger Dahlkvist (MO/EAB) 2006-05-02 12:02:24 eccn