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?
Re: Does the delete+insert is fater and less cpu consumer than update? |
| Список | 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.
В списке pgsql-general по дате отправления: