Which update action quicker?
От | Emi Lu |
---|---|
Тема | Which update action quicker? |
Дата | |
Msg-id | 5421D9FB.2030008@encs.concordia.ca обсуждение исходный текст |
Ответы |
Re: Which update action quicker?
|
Список | 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 по дате отправления: