Re: Running update in chunks?
Kevin Grittner <kgrittn@mail.com>
From: "Kevin Grittner" <kgrittn@mail.com>
To: "Richard Huxton" <dev@archonet.com>,pgsql-general@postgresql.org
Date: 2013-01-21T19:06:03Z
Lists: 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