Re: Update big table

Поиск
Список
Период
Сортировка
От bricklen
Тема Re: Update big table
Дата
Msg-id CAGrpgQ_hAmRSaNYwi_oU9kN9A-6=xBjksy6TQmv+7DAAhNLDow@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Update big table  (Haiming Zhang <Haiming.Zhang@redflex.com.au>)
Список pgsql-general

On Mon, Jul 15, 2013 at 6:08 AM, Haiming Zhang <Haiming.Zhang@redflex.com.au> wrote:
I run my query using JOIN for two hours, and did not get it done. Here is my query:

update table1 set col1 = true from table2 where table1.event_id = table2.event_id

Did you already post the query plan from "EXPLAIN update table1 set col1 = true from table2 where table1.event_id = table2.event_id" ?

В списке pgsql-general по дате отправления: