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 по дате отправления
От: Tom Lane
Дата:
От: Gokulakannan Somasundaram
Дата:
Сообщение: Re: Clarification about HOT
FAQ