Re: LogwrtResult contended spinlock

Поиск
Список
Период
Сортировка
Искать
От
Alvaro Herrera
Тема
Re: LogwrtResult contended spinlock
Дата
Msg-id
202111182215.hyrzuy7hbh3x@alvherre.pgsql
Ответ на
Список
Дерево обсуждения
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 по дате отправления
От: Tom Lane
Дата:
От: Melanie Plageman
Дата:
FAQ