> every update is a UPDATE ... WHERE id
>>= x AND id < x+10 and a commit is performed after every 1000 updates
> statement, i.e. every 10000 rows.
What is the rationale behind this? How about doing 10k rows in 1
update, and committing every time?
You could try making the condition on the ctid column, to not have to
use the index on ID, and process the rows in physical order. First
make sure that newly inserted production data has the correct value in
the new column, and add 'where new_column is null' to the conditions.
But I have never tried this, use at Your own risk.
In response to
pgsql-performance by date
|Next:||From: Carlo Stonebanks||Date: 2010-01-07 21:48:19|
|Subject: Re: Massive table (500M rows) update nightmare|
|Previous:||From: Robert Haas||Date: 2010-01-07 20:19:57|
|Subject: Re: noob inheritance question|