Re: update with no changes

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: update with no changes
Дата
Msg-id CAKFQuwbxNfRB0qSrp_Tjb0hZxXiozHMPdvY585GpsUWtrSu6xA@mail.gmail.com
обсуждение исходный текст
Ответ на update with no changes  (Marcos Pegoraro <marcos@f10.com.br>)
Ответы Re: update with no changes  (Marcos Pegoraro <marcos@f10.com.br>)
Список pgsql-hackers
Дерево обсуждения
On Fri, Nov 19, 2021 at 9:38 AM Marcos Pegoraro <marcos@f10.com.br> wrote:
If nothing was changed, why create a new record, append data to wal, set old record as deleted, etc, etc ?

Because it takes resources to determine that nothing changed.  If you want to opt-in into that there is even an extension trigger that makes doing so fairly simple.  But it's off by default because the typical case is that people don't frequently perform no-op updates so why eat the expense.

David J.

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

Предыдущее
От: Bharath Rupireddy
Дата:
Сообщение: Re: Shouldn't postgres_fdw report warning when it gives up getting result from foreign server?
Следующее
От: Andres Freund
Дата:
Сообщение: Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?)