Re: UPDATE many records - Mailing list pgsql-general

From Alan Hodgson
Subject Re: UPDATE many records
Date
Msg-id 86f7f7160d10a726541fd689c5a518102e3f50c5.camel@lists.simkin.ca
Whole thread Raw
In response to Re: UPDATE many records  (Israel Brewster <ijbrewster@alaska.edu>)
Responses Re: UPDATE many records
List pgsql-general
On Tue, 2020-01-07 at 11:47 -0900, Israel Brewster wrote:
> One potential issue I just thought of with this approach: disk space.
> Will I be doubling the amount of space used while both tables exist?
> If so, that would prevent this from working - I don’t have that much
> space available at the moment.

The original update you planned would do that, too.

You probably need to just do the update in batches and vacuum the table
between batches.




pgsql-general by date:

Previous
From: Thomas Munro
Date:
Subject: Re: Writing Postgres Extensions in C on Windows
Next
From: Israel Brewster
Date:
Subject: Re: UPDATE many records