Does the delete+insert is fater and less cpu consumer than update?

Поиск
Список
Период
Сортировка
От hmidi slim
Тема Does the delete+insert is fater and less cpu consumer than update?
Дата
Msg-id CAMsqVxtkRvvZ5UF0X3AXfr3gYA54keSk6T7AhZoHsguoMn_2rQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Does the delete+insert is fater and less cpu consumer than update?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Does the delete+insert is fater and less cpu consumer than update?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general
Дерево обсуждения
Hi,
I have a table named 'establishment' which has a join with a table 'category' and a table 'product'. I added indexes to foreign keys to enhance the execution time of the update or delete of data.
I have to update the table establishment when I get a new data received from an external api. The amount of updated data is about 3000-5000 rows.
I used an update query to update the modified rows, however when I search on the net I found that some people said that update is cpu intensive consumer and delete+insert is faster.
I didn't make any test for the performance between them and I want first of all to know if the update consumes more cpu in case of a large amount of data and with table with join.

В списке pgsql-general по дате отправления:

Предыдущее
От: Peter Devoy
Дата:
Сообщение: User-defined print format for extension-defined types in psql output
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Does the delete+insert is fater and less cpu consumer than update?