Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Mon, 30 Mar 2009 20:24:32 -0700
- Message-id: <7c1574a90903302024saa19e24ta1bec465d9879ffa@mail.gmail.com> <text/plain>
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?
- Follow-Ups:
- Re: performance: delete+insert versus update
- From: Tom Lane
- Re: performance: delete+insert versus update
- Prev by Date: Re: local disk access for a remote psql connection
- Next by Date: Re: performance: delete+insert versus update
- Previous by thread: local disk access for a remote psql connection
- Next by thread: Re: performance: delete+insert versus update
- Indexes: