Re: Insert vs Update - Mailing list pgsql-performance

From David G. Johnston
Subject Re: Insert vs Update
Date
Msg-id CAKFQuwbewGvGBDgYeuDpcFxfzW8VgD7RzEXUoPmS_CP8ujK2rQ@mail.gmail.com
Whole thread Raw
In response to Insert vs Update  (Robert DiFalco <robert.difalco@gmail.com>)
Responses Re: Insert vs Update
List pgsql-performance
On Wednesday, July 15, 2015, Robert DiFalco <robert.difalco@gmail.com> wrote:
First off I apologize if this is question has been beaten to death. I've looked around for a simple answer and could not find one. 

Given a database that will not have it's PKEY or indices modified, is it generally faster to INSERT or UPDATE data. And if there is a performance difference is it substantial?

This seems odd.  If you have an option to update but choose to insert what becomes of the other record? 

pgsql-performance by date:

Previous
From: Michael Nolan
Date:
Subject: Re: Insert vs Update
Next
From: Robert DiFalco
Date:
Subject: Re: Insert vs Update