Re: Running update in chunks?

Поиск
Список
Период
Сортировка
От Tim Uckun
Тема Re: Running update in chunks?
Дата
Msg-id CAGuHJrPojfKnROcvpRsHbY0OPYuDodEORYdYvyzPVE+TcmXMVg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Running update in chunks?  (Jeff Janes <jeff.janes@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Cast double precision to integer & check for overflow
Следующее
От: Paul Jones
Дата:
Сообщение: Can LC_TIME affect timestamp input?