Re: Insert vs Update

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Robert DiFalco <robert(dot)difalco(at)gmail(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Insert vs Update
Date: 2015-07-15 17:33:22
Message-ID: CAKFQuwbewGvGBDgYeuDpcFxfzW8VgD7RzEXUoPmS_CP8ujK2rQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wednesday, July 15, 2015, Robert DiFalco <robert(dot)difalco(at)gmail(dot)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?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Robert DiFalco 2015-07-15 17:56:26 Re: Insert vs Update
Previous Message Michael Nolan 2015-07-15 17:15:15 Re: Insert vs Update