performance: delete+insert versus update

From: Lonni J Friedman <netllama(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: performance: delete+insert versus update
Date: 2009-03-31 03:24:32
Message-ID: 7c1574a90903302024saa19e24ta1bec465d9879ffa@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Greetings,
I'm in the midst of a heated debate with a coworker over whether doing
a delete + insert is more expensive than doing an update. My belief
is that an update will usually be less expensive. Can anyone weigh
in?

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2009-03-31 04:56:09 Re: performance: delete+insert versus update
Previous Message Tom Lane 2009-03-31 00:07:40 Re: local disk access for a remote psql connection