Re: update with no changes - Mailing list pgsql-hackers

From Marcos Pegoraro
Subject Re: update with no changes
Date
Msg-id CAB-JLwY8Fvd1VA15wsRKPEC1ynhsXhSmswyBj1zxdLK3iF1wzw@mail.gmail.com
Whole thread Raw
In response to Re: update with no changes  ("David G. Johnston" <david.g.johnston@gmail.com>)
List 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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: xlog.c: removing ReadRecPtr and EndRecPtr
Next
From: Melanie Plageman
Date:
Subject: Re: Avoiding smgrimmedsync() during nbtree index builds