Re: Running update in chunks?

From: "Kevin Grittner" <kgrittn(at)mail(dot)com>
To: "Richard Huxton" <dev(at)archonet(dot)com>,pgsql-general(at)postgresql(dot)org
Subject: Re: Running update in chunks?
Date: 2013-01-21 19:06:03
Message-ID: 20130121190604.120600@gmx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2013-01-21 19:18:09 Re: What is impact of "varchar_opts"?
Previous Message Pavel Stehule 2013-01-21 18:04:14 Re: proposal: fix corner use case of variadic fuctions usage