| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | minimal update |
| Date: | 2007-11-02 15:49:38 |
| Message-ID: | 472B4712.3060704@dunslane.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
For some time I have been working on removing some inefficiencies from a
large DW-type app. This app does a large daily batch update, and this is
what is the major bottleneck. One of the things I have been doing is to
remove unnecessary updates (which are particualrly expensive in our
index-rich setting). Several times now I have wished that there was a
switch on the UPDATE command that said "do minimal instead of maximal
updating". i.e., don't update records with identical replacements. At
the moment I have to write things like:
update tname set foo = bar ... where foo is null or foo <> bar ...
This becomes more than tedious when the update might be setting thirty
or forty fields, and I have to write such tests for each of them. It
would be so much nicer to be able to write something like:
update tname minimally set foo = bar ...
Is this an insane idea, or would it be possible, practical and useful?
cheers
andrew
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gevik Babakhani | 2007-11-02 15:56:27 | Re: V0.1 patch for TODO Item: SQL-language reference parameters by name. |
| Previous Message | Gevik Babakhani | 2007-11-02 15:47:54 | Re: V0.1 patch for TODO Item: SQL-language reference parameters by name. |