Re: the s_lock_stuck on perform_spin_delay
От
Andy Fan
Тема
Re: the s_lock_stuck on perform_spin_delay
Дата
Msg-id
8734uz17va.fsf@163.com
Ответ на
Re: the s_lock_stuck on perform_spin_delay (Robert Haas)
Список
Дерево обсуждения
the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Andres Freund <andres@anarazel.de>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Andres Freund <andres@anarazel.de>
Re: the s_lock_stuck on perform_spin_delay Robert Haas <robertmhaas@gmail.com>
Re: the s_lock_stuck on perform_spin_delay Andres Freund <andres@anarazel.de>
Re: the s_lock_stuck on perform_spin_delay Robert Haas <robertmhaas@gmail.com>
Re: the s_lock_stuck on perform_spin_delay Andres Freund <andres@anarazel.de>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Robert Haas <robertmhaas@gmail.com>
Re: the s_lock_stuck on perform_spin_delay Tom Lane <tgl@sss.pgh.pa.us>
Re: the s_lock_stuck on perform_spin_delay Robert Haas <robertmhaas@gmail.com>
Re: the s_lock_stuck on perform_spin_delay Tom Lane <tgl@sss.pgh.pa.us>
Re: the s_lock_stuck on perform_spin_delay Robert Haas <robertmhaas@gmail.com>
Re: the s_lock_stuck on perform_spin_delay Andres Freund <andres@anarazel.de>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Robert Haas <robertmhaas@gmail.com>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Robert Haas <robertmhaas@gmail.com>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Matthias van de Meent <boekewurm+postgres@gmail.com>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Robert Haas <robertmhaas@gmail.com>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Robert Haas <robertmhaas@gmail.com>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Robert Haas <robertmhaas@gmail.com>
Re: the s_lock_stuck on perform_spin_delay Andres Freund <andres@anarazel.de>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Andres Freund <andres@anarazel.de>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Andres Freund <andres@anarazel.de>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Robert Haas <robertmhaas@gmail.com>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Robert Haas <robertmhaas@gmail.com>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Robert Haas <robertmhaas@gmail.com>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Robert Haas <robertmhaas@gmail.com>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Matthias van de Meent <boekewurm+postgres@gmail.com>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Robert Haas writes: > On Wed, Jan 10, 2024 at 10:17 PM Andy Fan wrote: >> fixed in v2. > > Timing the spinlock wait seems like a separate patch from the new sanity checks. Yes, a separate patch would be better, so removed it from v4. > I suspect that the new sanity checks should only be armed in > assert-enabled builds. There are 2 changes in v4. a). Make sure every code is only armed in assert-enabled builds. Previously there was some counter++ in non assert-enabled build. b). Record the location of spin lock so that whenever the Assert failure, we know which spin lock it is. In our internal testing, that helps a lot. -- Best Regards Andy Fan
В списке pgsql-hackers по дате отправления
От: vignesh C
Дата: