Re: [PERFORM] Adding new field to big table

2014-03-17 Thread Jeff Janes
On Monday, March 17, 2014, acanada wrote: > Hello, > > Jeff and Jeffrey thank you for your tips. > This is the explain of the query: > x=> explain update document as d set "svmConfidence" = st.svmconfidence > from svm_confidence_id_tmp as st where st.id = d.id; >

Re: [PERFORM] Adding new field to big table

2014-03-17 Thread acanada
Hello, Jeff and Jeffrey thank you for your tips. This is the explain of the query: x=> explain update document as d set "svmConfidence" = st.svmconfidence from svm_confidence_id_tmp as st where st.id = d.id; QUERY PLAN