Memory problems when using savepoints

Поиск
Список
Период
Сортировка
От Tim Baumgartner
Тема Memory problems when using savepoints
Дата
Msg-id 4457730B.2090001@gmx.de
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: "Robert Wimmer"
Дата:
Сообщение: Re: error handling
Следующее
От: "Tomeh, Husam"
Дата:
Сообщение: Re: stress tests problems