Re: pgsql: Add wait event for fsync of WAL segments

Поиск
Список
Период
Сортировка
Искать
От
Andres Freund
Тема
Re: pgsql: Add wait event for fsync of WAL segments
Дата
Msg-id
20180703191845.6dcmu5ku56wsqgoe@alap3.anarazel.de
Ответ на
Список
Дерево обсуждения
pgsql: Add wait event for fsync of WAL segments Michael Paquier <michael@paquier.xyz>
Re: pgsql: Add wait event for fsync of WAL segments Alvaro Herrera <alvherre@2ndquadrant.com>
Re: pgsql: Add wait event for fsync of WAL segments Michael Paquier <michael@paquier.xyz>
Re: pgsql: Add wait event for fsync of WAL segments Alvaro Herrera <alvherre@2ndquadrant.com>
Re: pgsql: Add wait event for fsync of WAL segments Andres Freund <andres@anarazel.de>
Re: pgsql: Add wait event for fsync of WAL segments Alvaro Herrera <alvherre@2ndquadrant.com>
Re: pgsql: Add wait event for fsync of WAL segments Michael Paquier <michael@paquier.xyz>
Re: pgsql: Add wait event for fsync of WAL segments Julien Rouhaud <rjuju123@gmail.com>
Re: pgsql: Add wait event for fsync of WAL segments Michael Paquier <michael@paquier.xyz>
Re: pgsql: Add wait event for fsync of WAL segments Tom Lane <tgl@sss.pgh.pa.us>
Re: pgsql: Add wait event for fsync of WAL segments Alvaro Herrera <alvherre@2ndquadrant.com>
Re: pgsql: Add wait event for fsync of WAL segments Peter Geoghegan <pg@bowt.ie>
Re: pgsql: Add wait event for fsync of WAL segments Michael Paquier <michael@paquier.xyz>
Re: pgsql: Add wait event for fsync of WAL segments Robert Haas <robertmhaas@gmail.com>
Hi,

On 2018-07-03 15:13:20 -0400, Alvaro Herrera wrote:
> Are the numerical values actually exposed to the world?  I thought the
> only way to this info was through the system views, which surely expose
> the names, not the numbers.

There's at least some work at high frequency sampling of these, and I
assume that's not going through SQL, but rather C functions.


> If reading wait events is actually possible, then it seems easy to
> backpatch this in pg10 by putting the new value at the end of the
> relevant enum, yeah.

Honestly, I don't really see an argument for backpatching this. If
people started measuring it might even invalidate their stats.

Greetings,

Andres Freund

В списке pgsql-committers по дате отправления
От: Alvaro Herrera
Дата:
От: Alvaro Herrera
Дата:
FAQ