Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!)

Поиск
Список
Период
Сортировка
Искать
От
Markus Wanner
Тема
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!)
Дата
Msg-id
4C85F65B.4010009@bluegap.ch
Ответ на
Список
Дерево обсуждения
CommitFest 2009-07: Yay, Kevin! Thanks, reviewers! Robert Haas <robertmhaas@gmail.com>
Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers! "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers! Greg Smith <greg@2ndquadrant.com>
Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers! Robert Haas <robertmhaas@gmail.com>
Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers! Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers! Alvaro Herrera <alvherre@commandprompt.com>
Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers! Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers! Magnus Hagander <magnus@hagander.net>
Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers! Tom Lane <tgl@sss.pgh.pa.us>
Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers! Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers! Tom Lane <tgl@sss.pgh.pa.us>
Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers! Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers! Tom Lane <tgl@sss.pgh.pa.us>
Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers! Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers! tomas@tuxteam.de
Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers! Tom Lane <tgl@sss.pgh.pa.us>
Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers! Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers! Tom Lane <tgl@sss.pgh.pa.us>
Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers! Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Tom Lane <tgl@sss.pgh.pa.us>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Tom Lane <tgl@sss.pgh.pa.us>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Alvaro Herrera <alvherre@commandprompt.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Fujii Masao <masao.fujii@gmail.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Fujii Masao <masao.fujii@gmail.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Fujii Masao <masao.fujii@gmail.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Fujii Masao <masao.fujii@gmail.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Tom Lane <tgl@sss.pgh.pa.us>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Tom Lane <tgl@sss.pgh.pa.us>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Tom Lane <tgl@sss.pgh.pa.us>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Tom Lane <tgl@sss.pgh.pa.us>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Tom Lane <tgl@sss.pgh.pa.us>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Markus Wanner <markus@bluegap.ch>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Martijn van Oosterhout <kleptog@svana.org>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Tom Lane <tgl@sss.pgh.pa.us>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Tom Lane <tgl@sss.pgh.pa.us>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Markus Wanner <markus@bluegap.ch>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Tom Lane <tgl@sss.pgh.pa.us>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Markus Wanner <markus@bluegap.ch>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Markus Wanner <markus@bluegap.ch>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Tom Lane <tgl@sss.pgh.pa.us>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Markus Wanner <markus@bluegap.ch>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Markus Wanner <markus@bluegap.ch>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Tom Lane <tgl@sss.pgh.pa.us>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Jeff Davis <pgsql@j-davis.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Tom Lane <tgl@sss.pgh.pa.us>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Jeff Davis <pgsql@j-davis.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Tom Lane <tgl@sss.pgh.pa.us>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Jeff Davis <pgsql@j-davis.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Jeff Davis <pgsql@j-davis.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Jeff Davis <pgsql@j-davis.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Fujii Masao <masao.fujii@gmail.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Tom Lane <tgl@sss.pgh.pa.us>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Fujii Masao <masao.fujii@gmail.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Tom Lane <tgl@sss.pgh.pa.us>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Robert Haas <robertmhaas@gmail.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Tom Lane <tgl@sss.pgh.pa.us>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Ron Mayer <rm_pg@cheapcomplexdevices.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Robert Haas <robertmhaas@gmail.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Robert Haas <robertmhaas@gmail.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Tom Lane <tgl@sss.pgh.pa.us>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Greg Stark <gsstark@mit.edu>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Robert Haas <robertmhaas@gmail.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Tom Lane <tgl@sss.pgh.pa.us>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Simon Riggs <simon@2ndQuadrant.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Robert Haas <robertmhaas@gmail.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Greg Smith <greg@2ndquadrant.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Tom Lane <tgl@sss.pgh.pa.us>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Bruce Momjian <bruce@momjian.us>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Greg Smith <greg@2ndquadrant.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Greg Stark <gsstark@mit.edu>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Robert Haas <robertmhaas@gmail.com>
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!) Tom Lane <tgl@sss.pgh.pa.us>
On 09/07/2010 09:06 AM, Heikki Linnakangas wrote:
> Setting a latch that's already set is very fast, so you want to keep it
> set until the last moment. See the coding in walsender for example, it
> goes to some lengths to avoid clearing the latch until it's very sure
> there's no more work for it to do. That helps to keep the overhead in
> backends committing transactions low. (no-one has tried to measure that
> yet, though)

Understood, thanks.

Markus

В списке pgsql-hackers по дате отправления
От: Markus Wanner
Дата:
От: Pavel Stehule
Дата:
FAQ