Re: [GENERAL] transaction control in pl/pgsql

2010-04-12 Thread Birgit Laggner
wrote: > On Thu, Apr 1, 2010 at 6:22 AM, Birgit Laggner > wrote: > >> Dear list, >> >> I have some data (big size) and I've written a long function in pl/pgsql >> which processes the data in several steps. At a test run my function >> aborted because o

Re: [GENERAL] transaction control in pl/pgsql

2010-04-01 Thread Birgit Laggner
ippet... I you have any ideas ... Thanks again and regards, Birgit. On 01.04.2010 13:27, Alban Hertroys wrote: > On 1 Apr 2010, at 12:22, Birgit Laggner wrote: > > >> Dear list, >> >> I have some data (big size) and I've written a long function in pl/pgsql >>

Re: [GENERAL] transaction control in pl/pgsql

2010-04-01 Thread Birgit Laggner
Hi Grzegorz, sorry, but that doesn't help me, perhaps you could get a little bit clearer: @a) Does the use of SAVEPOINT avoid memory overflow? I could not find an explanation about memory use in the documentation of SAVEPOINT. @b) Do you mean I should not process my data or I should not use plpg

[GENERAL] transaction control in pl/pgsql

2010-04-01 Thread Birgit Laggner
Dear list, I have some data (big size) and I've written a long function in pl/pgsql which processes the data in several steps. At a test run my function aborted because of memory exhaustion. My guess is, that everything what happens during the function transaction is stored in the memory - until i