Re: How to avoid UPDATE performance degradation in a transaction

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: How to avoid UPDATE performance degradation in a transaction
Дата
Msg-id CAHOFxGpdHR5XaNmuRczmkGUnWop5uVdURuvVs0HBoi3Nrusi6g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to avoid UPDATE performance degradation in a transaction  (Karl Düüna <karl.dyyna@gmail.com>)
Список pgsql-performance
If your trigger is supposed to change certain fields, you could return OLD instead of NEW if those fields have not been changed by the trigger. You could also check an updated_on timestamp field to verify if the row has already been modified and potentially skip the trigger altogether. Just a couple thoughts to avoid the bloat.

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