Re: Running update in chunks? - Mailing list pgsql-general

From Kevin Grittner
Subject Re: Running update in chunks?
Date
Msg-id 20130121190604.120600@gmx.com
Whole thread Raw
In response to Running update in chunks?  (Tim Uckun <timuckun@gmail.com>)
Responses Re: Running update in chunks?  (Tim Uckun <timuckun@gmail.com>)
List pgsql-general
Richard Huxton wrote:

> The only differences I can think of are WAL logging (transaction
> log) and index updates (the temp table has no indexes).

What about foreign keys? Are there any tables which reference the
updated column in a foreign key declaration? Do they have indexes
on that column?

-Kevin


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: pg_Restore
Next
From: Tom Lane
Date:
Subject: Re: What is impact of "varchar_opts"?