Re: :Posgres - performance problem

From: Marc Mamin <M(dot)Mamin(at)intershop(dot)de>
To: ginkgo36 <ginkgo56(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: :Posgres - performance problem
Date: 2015-03-26 17:31:57
Message-ID: B6F6FD62F2624C4C9916AC0175D56D8828BA8900@jenmbs01.ad.intershop.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> update master_items set "feedback_to_de" = 'Yes'
>--Query returned successfully: 591268 rows affected, 1589335 ms execution time.

Here you should better use
update master_items set feedback_to_de = 'Yes' WHERE feedback_to_de <> 'Yes'
OR
update master_items set feedback_to_de <> 'Yes' WHERE feedback_to_de IS DISTINCT FROM 'Yes'
depending on the column nullable.

regards,
Marc Mamin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kretschmer 2015-03-26 17:53:22 Re: 9.4+ partial log-shipping possible?
Previous Message Leonardo M. Ramé 2015-03-26 17:30:33 Re: Column does not exists?