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

From Tim Uckun
Subject Re: Running update in chunks?
Date
Msg-id CAGuHJrPojfKnROcvpRsHbY0OPYuDodEORYdYvyzPVE+TcmXMVg@mail.gmail.com
Whole thread Raw
In response to Re: Running update in chunks?  (Jeff Janes <jeff.janes@gmail.com>)
List 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.


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Cast double precision to integer & check for overflow
Next
From: Paul Jones
Date:
Subject: Can LC_TIME affect timestamp input?