Horton

Re: Running update in chunks?

Tim Uckun <timuckun@gmail.com>

View thread View on postgr.es
From: Tim Uckun <timuckun@gmail.com>
To: Jeff Janes <jeff.janes@gmail.com>
Cc: Richard Huxton <dev@archonet.com>, Kevin Grittner <kgrittn@mail.com>, "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Date: 2013-01-27T00:55:05Z
Lists: pgsql-general 
>
> That would be one solution, but I think a better one would be to not
> store "make_id" in "imports" in the first place, but instead to always
> fetch it by joining "imports" to "models" at query time.
>

My problem here is that the incoming data is quite messy so the join
conditions become weird (lots of ORs and such). A multi pass approach
seems to work better.