Postgres Pro
Downloads
Home   >   mailing lists

Re: Update and cursor - Mailing list pgsql-general

From Tom Lane
Subject Re: Update and cursor
Date
Msg-id 22562.992958915@sss.pgh.pa.us
Whole thread Raw
In response to Update and cursor  (Patrick COLLIN <patrick@felixfr.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Vilson farias"
Date:
Subject: Still getting problems with -cache lookup for userid 26 failed-
Next
From: Tom Lane
Date:
Subject: Re: rule on insert with default values for new instance