On Mon, Jul 15, 2013 at 6:08 AM, Haiming Zhang <haiming.zh...@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" ?