Re: Update and cursor

Patrick COLLIN <patrick@felixfr.com> writes:
> I need to update 300,000 records with many tests on each before
> updating.
> I first tried a global update on each column, but I have not enough
> memory and swap to do that.

If this is 7.1, I'd be interested to see the query and the table
schemas.

If it isn't, time to update.  Older versions leak too much memory...

            regards, tom lane