Re: update with no changes

Поиск
Список
Период
Сортировка
От Marcos Pegoraro
Тема Re: update with no changes
Дата
Msg-id CAB-JLwY8Fvd1VA15wsRKPEC1ynhsXhSmswyBj1zxdLK3iF1wzw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: update with no changes  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-hackers
I suppose if the application side cannot be trusted to code to a specification without having the server side add validation and/or compensation code to catch the bugs then, yes, one option is to have the server side do extra work.  There are other solutions, some of which are not even technical in nature.

Just to show you my problem, since I wrote my first email of this discussion, I changed a little my auditing trigger to get total of records being updated. Only last 3 or 4 hours we´re talking, we had 12% of them with no changes. It is a lot.

Thanks again, we have a huge code review here.

regards, 
Marcos
 

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: xlog.c: removing ReadRecPtr and EndRecPtr
Следующее
От: Melanie Plageman
Дата:
Сообщение: Re: Avoiding smgrimmedsync() during nbtree index builds