[PostgreSQL] Running update in chunks?

[PostgreSQL] Running update in chunks?

	Kevin Grittner
	Jan 21, 2013 at 7:06 pm

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

Search Discussions

Discussion Posts

Richard Huxton: OK - so writing all the data takes very under one second but updating the same amount takes 50 seconds. The only differences I can think of are WAL logging (transaction log) and index updates (the temp table has no indexes). 1. Try CREATE TABLE rather than CREATE TEMP TABLE - if that's still quick then it's not the time taken to write WAL. 2. Run the update query against your new tt table and see how long that takes. 3. Add indexes and repeat (in particular I'd be suspicious of the gin index on

Follow ups

Related Discussions

Discussion Navigation

view	thread \| post
posts	‹ prev \| 5 of 38 \| next ›

Discussion Overview

group	pgsql-general @
categories	postgresql
posted	Jan 21, '13 at 8:04a
active	Jan 27, '13 at 10:28a
posts	38
users	9
website	postgresql.org
irc	#postgresql

font	variable	Hotkey: f
user style	avatars	Hotkey: a

[PostgreSQL] Running update in chunks?

Search Discussions

Discussion Posts

Related Discussions

9 users in discussion