Postgres Pro
Downloads
Home   >   mailing lists

performance: delete+insert versus update - Mailing list pgsql-novice

From Lonni J Friedman
Subject performance: delete+insert versus update
Date
Msg-id 7c1574a90903302024saa19e24ta1bec465d9879ffa@mail.gmail.com
Whole thread Raw
Responses Re: performance: delete+insert versus update  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Tree view 
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?

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: local disk access for a remote psql connection
Next
From: Tom Lane
Date:
Subject: Re: performance: delete+insert versus update