Re: Insert vs Update

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Insert vs Update
Дата
Msg-id CAKFQuwbewGvGBDgYeuDpcFxfzW8VgD7RzEXUoPmS_CP8ujK2rQ@mail.gmail.com
обсуждение исходный текст
Ответ на Insert vs Update  (Robert DiFalco <robert.difalco@gmail.com>)
Ответы Re: Insert vs Update  (Robert DiFalco <robert.difalco@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Michael Nolan
Дата:
Сообщение: Re: Insert vs Update
Следующее
От: Robert DiFalco
Дата:
Сообщение: Re: Insert vs Update