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

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!)
Дата
Msg-id
487.1283550725@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
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>
Heikki Linnakangas  writes:
> A safer approach would be to just PGSemaphoreUnlock() in the signal 
> handler, and do all the other processing outside it.

I don't see any particularly good reason to assume that
PGSemaphoreUnlock is safe either: you're still talking about nested
semop operations.

The pre-existing SIGALRM handler uses a self-signal (kill(MyProcPid,
SIGINT)) to kick the process off any wait it might be doing.  I'd rather
do something like that.

Or maybe the work you're doing on latches would help ...
		regards, tom lane

В списке pgsql-hackers по дате отправления
От: Robert Haas
Дата:
От: Tom Lane
Дата:
FAQ