Which update action quicker? - Mailing list pgsql-performance

From Emi Lu
Subject Which update action quicker?
Date
Msg-id 5421D9FB.2030008@encs.concordia.ca
Whole thread Raw
Responses Re: Which update action quicker?  (Heikki Linnakangas <hlinnakangas@vmware.com>)
List pgsql-performance
<div class="moz-text-flowed" lang="x-western" style="font-size: 18px;"><small>Hello list, <br /><br /> For a big table
withmore than 1,000,000 records, may I know which update is quicker please? <br /><br /> (1) update t1 <br />       set
c1= a.c1 <br />       from a <br />       where pk and <br />                  t1.c1       <> a.c1; <br />
 ......<br />       update t1 <br />       set c_N = a.c_N <br />       from a <br />       where pk and <br />
                t1.c_N       <> a.c_N; <br /><br /><br /> (2)  update t1 <br />       set c1 = a.c1 , <br />
           c2  = a.c2, <br />             ... <br />             c_N = a.c_N <br />      from a <br />      where pk
AND<br />                (  t1.c1 <> a.c1 OR t1.c2 <> a.c2..... t1.c_N <> a.c_N) <br /><br /><br />
Orother quicker way for update action? <br /><br /> Thank you <br /> Emi </small><br /></div> 

pgsql-performance by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: postgres 9.3 vs. 9.4
Next
From: "Mkrtchyan, Tigran"
Date:
Subject: Re: postgres 9.3 vs. 9.4