Re: LogwrtResult contended spinlock
От
Alvaro Herrera
Тема
Re: LogwrtResult contended spinlock
Дата
Msg-id
202111182215.hyrzuy7hbh3x@alvherre.pgsql
Ответ на
Re: LogwrtResult contended spinlock (Andres Freund)
Список
Дерево обсуждения
LogwrtResult contended spinlock Alvaro Herrera <alvherre@2ndquadrant.com>
Re: LogwrtResult contended spinlock Andres Freund <andres@anarazel.de>
Re: LogwrtResult contended spinlock Alvaro Herrera <alvherre@2ndquadrant.com>
Re: LogwrtResult contended spinlock Andres Freund <andres@anarazel.de>
Re: LogwrtResult contended spinlock Alvaro Herrera <alvherre@2ndquadrant.com>
Re: LogwrtResult contended spinlock Andres Freund <andres@anarazel.de>
Re: LogwrtResult contended spinlock Andres Freund <andres@anarazel.de>
Re: LogwrtResult contended spinlock Anastasia Lubennikova <a.lubennikova@postgrespro.ru>
Re: LogwrtResult contended spinlock Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: LogwrtResult contended spinlock Masahiko Sawada <sawada.mshk@gmail.com>
Re: LogwrtResult contended spinlock Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: LogwrtResult contended spinlock Masahiko Sawada <sawada.mshk@gmail.com>
Re: LogwrtResult contended spinlock Alvaro Herrera <alvherre@2ndquadrant.com>
Re: LogwrtResult contended spinlock Alvaro Herrera <alvherre@2ndquadrant.com>
Re: LogwrtResult contended spinlock Andres Freund <andres@anarazel.de>
Re: LogwrtResult contended spinlock Alvaro Herrera <alvherre@2ndquadrant.com>
Re: LogwrtResult contended spinlock Andres Freund <andres@anarazel.de>
Re: LogwrtResult contended spinlock Jaime Casanova <jcasanov@systemguards.com.ec>
Re: LogwrtResult contended spinlock Daniel Gustafsson <daniel@yesql.se>
Re: LogwrtResult contended spinlock Andres Freund <andres@anarazel.de>
Re: LogwrtResult contended spinlock Alvaro Herrera <alvherre@2ndquadrant.com>
Re: LogwrtResult contended spinlock Alvaro Herrera <alvherre@2ndquadrant.com>
Re: LogwrtResult contended spinlock Andres Freund <andres@anarazel.de>
Re: LogwrtResult contended spinlock Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: LogwrtResult contended spinlock Tom Lane <tgl@sss.pgh.pa.us>
Re: LogwrtResult contended spinlock Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: LogwrtResult contended spinlock Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: LogwrtResult contended spinlock Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: LogwrtResult contended spinlock Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: LogwrtResult contended spinlock Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: LogwrtResult contended spinlock Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: LogwrtResult contended spinlock Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: LogwrtResult contended spinlock Jeff Davis <pgsql@j-davis.com>
Re: LogwrtResult contended spinlock Jeff Davis <pgsql@j-davis.com>
Re: LogwrtResult contended spinlock Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: LogwrtResult contended spinlock Jeff Davis <pgsql@j-davis.com>
Re: LogwrtResult contended spinlock Robert Haas <robertmhaas@gmail.com>
Re: LogwrtResult contended spinlock Jeff Davis <pgsql@j-davis.com>
Re: LogwrtResult contended spinlock Robert Haas <robertmhaas@gmail.com>
Re: LogwrtResult contended spinlock Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: LogwrtResult contended spinlock Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: LogwrtResult contended spinlock Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: LogwrtResult contended spinlock Jeff Davis <pgsql@j-davis.com>
Re: LogwrtResult contended spinlock Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: LogwrtResult contended spinlock Jeff Davis <pgsql@j-davis.com>
Re: LogwrtResult contended spinlock Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: LogwrtResult contended spinlock Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: LogwrtResult contended spinlock Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: LogwrtResult contended spinlock Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: LogwrtResult contended spinlock Thomas Munro <thomas.munro@gmail.com>
Re: LogwrtResult contended spinlock Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: LogwrtResult contended spinlock Jeff Davis <pgsql@j-davis.com>
Re: LogwrtResult contended spinlock Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: LogwrtResult contended spinlock Jeff Davis <pgsql@j-davis.com>
Re: LogwrtResult contended spinlock Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: LogwrtResult contended spinlock Alexander Lakhin <exclusion@gmail.com>
Re: LogwrtResult contended spinlock Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: LogwrtResult contended spinlock Alexander Lakhin <exclusion@gmail.com>
Re: LogwrtResult contended spinlock Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: LogwrtResult contended spinlock Andres Freund <andres@anarazel.de>
Re: LogwrtResult contended spinlock Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: LogwrtResult contended spinlock Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: LogwrtResult contended spinlock Andres Freund <andres@anarazel.de>
Re: LogwrtResult contended spinlock Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: LogwrtResult contended spinlock Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: LogwrtResult contended spinlock Tom Lane <tgl@sss.pgh.pa.us>
Re: LogwrtResult contended spinlock Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: LogwrtResult contended spinlock Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: LogwrtResult contended spinlock Tom Lane <tgl@sss.pgh.pa.us>
Re: LogwrtResult contended spinlock Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: LogwrtResult contended spinlock Alexander Lakhin <exclusion@gmail.com>
Re: LogwrtResult contended spinlock Jeff Davis <pgsql@j-davis.com>
Re: LogwrtResult contended spinlock Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: LogwrtResult contended spinlock Jeff Davis <pgsql@j-davis.com>
Re: LogwrtResult contended spinlock Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: LogwrtResult contended spinlock Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: LogwrtResult contended spinlock Alvaro Herrera <alvherre@alvh.no-ip.org>
Here's a further attempt at this. Sorry it took so long. In this version, I replaced the coupled-in-a-struct representation of Write&Flush with two separate global variables. The reason to do this is to cater to Andres' idea to keep them up-to-date separately. Of course, I could kept them together, but it seems more sensible this way. Andres also suggested to not use monotonic-advance in XLogWrite, because these update are always done with WALWriteLock held in exclusive mode. However, that doesn't work (and tests fail pretty quickly) because XLogWrite seems to be called possibly out of order, so you still have to check if the current value is newer than what you have to write anyway; using stock atomic write doesn't work. So this is v4. -- Álvaro Herrera 39°49'30"S 73°17'W — https://www.EnterpriseDB.com/
В списке pgsql-hackers по дате отправления
От: Melanie Plageman
Дата: