Re: Deadlock bug
От
Tom Lane
Тема
Re: Deadlock bug
Дата
Msg-id
20022.1282748248@sss.pgh.pa.us
Ответ на
Re: Deadlock bug (Nicolas Barbier)
Список
Дерево обсуждения
Deadlock bug Joel Jacobson <joel@gluefinance.com>
Re: Deadlock bug Tom Lane <tgl@sss.pgh.pa.us>
Re: Deadlock bug "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Deadlock bug Tom Lane <tgl@sss.pgh.pa.us>
Re: Deadlock bug Joel Jacobson <joel@gluefinance.com>
Re: Deadlock bug Tom Lane <tgl@sss.pgh.pa.us>
Re: Deadlock bug Josh Berkus <josh@agliodbs.com>
Re: Deadlock bug Tom Lane <tgl@sss.pgh.pa.us>
Re: Deadlock bug Simon Riggs <simon@2ndQuadrant.com>
Re: Deadlock bug Markus Wanner <markus@bluegap.ch>
Re: Deadlock bug Simon Riggs <simon@2ndQuadrant.com>
Re: Deadlock bug Nicolas Barbier <nicolas.barbier@gmail.com>
Re: Deadlock bug Simon Riggs <simon@2ndQuadrant.com>
Re: Deadlock bug Nicolas Barbier <nicolas.barbier@gmail.com>
Re: Deadlock bug Tom Lane <tgl@sss.pgh.pa.us>
Re: Deadlock bug Markus Wanner <markus@bluegap.ch>
Re: Deadlock bug Josh Berkus <josh@agliodbs.com>
Re: Deadlock bug Tom Lane <tgl@sss.pgh.pa.us>
Re: Deadlock bug Greg Stark <gsstark@mit.edu>
Re: Deadlock bug Tom Lane <tgl@sss.pgh.pa.us>
Re: Deadlock bug Simon Riggs <simon@2ndQuadrant.com>
Re: Deadlock bug Josh Berkus <josh@agliodbs.com>
Re: Deadlock bug Markus Wanner <markus@bluegap.ch>
Re: Deadlock bug Greg Stark <gsstark@mit.edu>
Re: Deadlock bug Robert Haas <robertmhaas@gmail.com>
Re: Deadlock bug Joel Jacobson <joel@gluefinance.com>
Re: Deadlock bug Tom Lane <tgl@sss.pgh.pa.us>
Re: [Glue] Deadlock bug Josh Berkus <josh@agliodbs.com>
Re: Deadlock bug Joel Jacobson <joel@gluefinance.com>
Re: Deadlock bug Tom Lane <tgl@sss.pgh.pa.us>
Re: Deadlock bug Joel Jacobson <joel@gluefinance.com>
Re: [Glue] Deadlock bug Josh Berkus <josh@agliodbs.com>
Re: [Glue] Deadlock bug "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: [Glue] Deadlock bug "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: [Glue] Deadlock bug Josh Berkus <josh@agliodbs.com>
Re: [Glue] Deadlock bug Joel Jacobson <joel@gluefinance.com>
Re: [Glue] Deadlock bug Josh Berkus <josh@agliodbs.com>
Re: [Glue] Deadlock bug Greg Stark <gsstark@mit.edu>
Re: [Glue] Deadlock bug Joel Jacobson <joel@gluefinance.com>
Re: [Glue] Deadlock bug Greg Stark <gsstark@mit.edu>
Nicolas Barbier writes: > 2010/8/25 Simon Riggs : >> You're exactly correct and I now understand Markus' comment. Do you >> think that exact meaning prevents my proposal from being useful? > Not at all, because I guess that updates to non-UNIQUE columns are way > more common that updates to UNIQUE columns. In particular, HOT updates are known useful even though they have that restriction and more. It strikes me that a possibly useful simplification of the idea is a lock type that allows HOT updates and not non-HOT ones; or more precisely not ones that change any indexed columns --- if the row ends up having to go off-page for lack of space, that need not concern us. regards, tom lane
В списке pgsql-hackers по дате отправления
