updates not causing changes - Mailing list pgsql-general

From Torsten Förtsch
Subject updates not causing changes
Date
Msg-id 5399E1F1.7090005@gmx.net
Whole thread Raw
Responses Re: updates not causing changes
List pgsql-general
Hi,

our developers use a ORM tool which generates updates that write all
columns of a table. In most cases, however, very few columns actually
change. So, those updates mostly write the same value that already is
there in the column.

Now, if there is an index on such columns, does Postgres recognize the
situation and skip the index update? Similarly, does it skip the FK or
UNIQUE check?

Thanks,
Torsten


pgsql-general by date:

Previous
From: Bosco Rama
Date:
Subject: Re: HOT standby with ONLY WAL shipping?
Next
From: Keith Fiske
Date:
Subject: Re: [HACKERS] Question about partial functional indexes and the query planner