Re: Update and cursor

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Patrick COLLIN <patrick(at)felixfr(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Update and cursor
Date: 2001-06-19 13:55:15
Message-ID: 22562.992958915@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Patrick COLLIN <patrick(at)felixfr(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-06-19 14:03:31 Re: rule on insert with default values for new instance
Previous Message Tom Lane 2001-06-19 13:52:43 Re: [Help] Temporary Table: Implicitely created index not shown in \d i