Обсуждение: Memory problems when using savepoints

Поиск
Список
Период
Сортировка

Memory problems when using savepoints

От
Tim Baumgartner
Дата:
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