minimal update
От
Andrew Dunstan
Тема
minimal update
Дата
Msg-id
472B4712.3060704@dunslane.net
Список
Дерево обсуждения
minimal update Andrew Dunstan <andrew@dunslane.net>
Re: minimal update David Fetter <david@fetter.org>
Re: minimal update Tom Lane <tgl@sss.pgh.pa.us>
Re: minimal update Andrew Dunstan <andrew@dunslane.net>
Re: minimal update Tom Lane <tgl@sss.pgh.pa.us>
Re: minimal update Andrew Dunstan <andrew@dunslane.net>
Re: minimal update Michael Glaesemann <grzm@seespotcode.net>
Re: minimal update Tom Lane <tgl@sss.pgh.pa.us>
Re: minimal update Andrew Dunstan <andrew@dunslane.net>
Re: minimal update Bruce Momjian <bruce@momjian.us>
Re: minimal update "Gurjeet Singh" <singh.gurjeet@gmail.com>
Re: minimal update Andrew Dunstan <andrew@dunslane.net>
Re: minimal update "Gurjeet Singh" <singh.gurjeet@gmail.com>
Re: minimal update Bruce Momjian <bruce@momjian.us>
Re: minimal update Andrew Dunstan <andrew@dunslane.net>
Re: minimal update Bruce Momjian <bruce@momjian.us>
Re: minimal update Andrew Dunstan <andrew@dunslane.net>
Re: minimal update Bruce Momjian <bruce@momjian.us>
Re: minimal update Andrew Dunstan <andrew@dunslane.net>
Re: minimal update Andrew Dunstan <andrew@dunslane.net>
Re: minimal update Bruce Momjian <bruce@momjian.us>
Re: minimal update Andrew Dunstan <andrew@dunslane.net>
Re: minimal update Tom Lane <tgl@sss.pgh.pa.us>
Re: minimal update Andrew Dunstan <andrew@dunslane.net>
Re: minimal update Magnus Hagander <magnus@hagander.net>
Re: minimal update Andrew Dunstan <andrew@dunslane.net>
Re: minimal update Magnus Hagander <magnus@hagander.net>
Re: minimal update Tom Lane <tgl@sss.pgh.pa.us>
Re: minimal update Andrew Dunstan <andrew@dunslane.net>
Re: minimal update Andrew Dunstan <andrew@dunslane.net>
Re: minimal update Simon Riggs <simon@2ndQuadrant.com>
Re: minimal update Tom Lane <tgl@sss.pgh.pa.us>
Re: minimal update "Robert Haas" <robertmhaas@gmail.com>
Re: minimal update Simon Riggs <simon@2ndQuadrant.com>
Re: minimal update Tom Lane <tgl@sss.pgh.pa.us>
Re: minimal update Kenneth Marshall <ktm@rice.edu>
Re: minimal update Andrew Dunstan <andrew@dunslane.net>
Re: minimal update Alvaro Herrera <alvherre@commandprompt.com>
Re: minimal update Andrew Dunstan <andrew@dunslane.net>
Re: minimal update David Fetter <david@fetter.org>
Re: minimal update Andrew Dunstan <andrew@dunslane.net>
Re: minimal update Andrew Dunstan <andrew@dunslane.net>
Re: minimal update Tom Lane <tgl@sss.pgh.pa.us>
Re: minimal update Tom Lane <tgl@sss.pgh.pa.us>
Re: minimal update Magnus Hagander <magnus@hagander.net>
Re: minimal update "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: minimal update "Robert Haas" <robertmhaas@gmail.com>
Re: minimal update Andrew Dunstan <andrew@dunslane.net>
Re: minimal update Decibel! <decibel@decibel.org>
Re: minimal update "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: minimal update Andrew Dunstan <andrew@dunslane.net>
Re: minimal update David Fetter <david@fetter.org>
Re: minimal update "Merlin Moncure" <mmoncure@gmail.com>
Re: minimal update Michael Glaesemann <grzm@seespotcode.net>
Re: minimal update Andrew Dunstan <andrew@dunslane.net>
Re: minimal update Tom Lane <tgl@sss.pgh.pa.us>
Re: minimal update Andrew Dunstan <andrew@dunslane.net>
Re: minimal update Tom Lane <tgl@sss.pgh.pa.us>
Re: minimal update Andrew Dunstan <andrew@dunslane.net>
Re: minimal update Andrew Dunstan <andrew@dunslane.net>
Re: minimal update Decibel! <decibel@decibel.org>
Re: minimal update Andrew Dunstan <andrew@dunslane.net>
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
В списке pgsql-hackers по дате отправления