Re: continuous copy/update one table to another

Поиск
Список
Период
Сортировка
Искать
От
Szymon Guz
Тема
Re: continuous copy/update one table to another
Дата
Msg-id
e4edc9361003010059w37c8884aof6f66893228e32a8@mail.gmail.com
Ответ на
Список
Дерево обсуждения
continuous copy/update one table to another Terry <td3201@gmail.com>
Re: continuous copy/update one table to another David W Noon <dwnoon@ntlworld.com>
Re: continuous copy/update one table to another Adrian von Bidder <avbidder@fortytwo.ch>
Re: continuous copy/update one table to another John R Pierce <pierce@hogranch.com>
Re: continuous copy/update one table to another Szymon Guz <mabewlun@gmail.com>
Re: continuous copy/update one table to another John R Pierce <pierce@hogranch.com>
Re: continuous copy/update one table to another Terry <td3201@gmail.com>
Re: continuous copy/update one table to another Terry <td3201@gmail.com>
Re: continuous copy/update one table to another John R Pierce <pierce@hogranch.com>
Re: continuous copy/update one table to another Terry <td3201@gmail.com>
Re: continuous copy/update one table to another Terry <td3201@gmail.com>
Re: continuous copy/update one table to another Grzegorz Jaśkiewicz <gryzman@gmail.com>
Re: continuous copy/update one table to another Szymon Guz <mabewlun@gmail.com>
Re: continuous copy/update one table to another Tom Lane <tgl@sss.pgh.pa.us>

W dniu 1 marca 2010 09:40 użytkownik Grzegorz Jaśkiewicz <gryzman@gmail.com> napisał:
don't use 'NOT EXISTS', as this will be damn slow. Use LEFT JOIN.


Right, LEFT JOIN should be faster (with proper indices even much faster).
В списке pgsql-general по дате отправления
От: Grzegorz Jaśkiewicz
Дата:
От: Adrian von Bidder
Дата:
FAQ