Re: Does the delete+insert is fater and less cpu consumer than update?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: hmidi slim <hmidi(dot)slim2(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Does the delete+insert is fater and less cpu consumer than update?
Date: 2017-12-14 22:32:56
Message-ID: 25846.1513290776@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hmidi slim <hmidi(dot)slim2(at)gmail(dot)com> writes:
> I used an update query to update the modified rows, however when I search
> on the net I found that some people said that update is cpu intensive
> consumer and delete+insert is faster.

It's possible that there are RDBMSes somewhere for which that is true.
But as far as Postgres is concerned, it's nonsense.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2017-12-14 22:44:12 Re: Does the delete+insert is fater and less cpu consumer than update?
Previous Message hmidi slim 2017-12-14 22:08:30 Does the delete+insert is fater and less cpu consumer than update?