RE: WIP: WAL prefetch (another approach)

Поиск
Список
Период
Сортировка
Искать
От
Shinoda, Noriyoshi (PN Japan FSIP)
Тема
RE: WIP: WAL prefetch (another approach)
Дата
Msg-id
TU4PR8401MB1152945E4FD45E99C3F52B94EE4F9@TU4PR8401MB1152.NAMPRD84.PROD.OUTLOOK.COM
Ответ на
Список
Дерево обсуждения
WIP: WAL prefetch (another approach) Thomas Munro <thomas.munro@gmail.com>
Re: WIP: WAL prefetch (another approach) Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: WIP: WAL prefetch (another approach) Thomas Munro <thomas.munro@gmail.com>
Re: WIP: WAL prefetch (another approach) Thomas Munro <thomas.munro@gmail.com>
Re: WIP: WAL prefetch (another approach) Thomas Munro <thomas.munro@gmail.com>
Re: WIP: WAL prefetch (another approach) Alvaro Herrera <alvherre@2ndquadrant.com>
Re: WIP: WAL prefetch (another approach) Thomas Munro <thomas.munro@gmail.com>
Re: WIP: WAL prefetch (another approach) Alvaro Herrera <alvherre@2ndquadrant.com>
Re: WIP: WAL prefetch (another approach) Thomas Munro <thomas.munro@gmail.com>
Re: WIP: WAL prefetch (another approach) Andres Freund <andres@anarazel.de>
Re: WIP: WAL prefetch (another approach) Thomas Munro <thomas.munro@gmail.com>
Re: WIP: WAL prefetch (another approach) Thomas Munro <thomas.munro@gmail.com>
Re: WIP: WAL prefetch (another approach) Thomas Munro <thomas.munro@gmail.com>
Re: WIP: WAL prefetch (another approach) Thomas Munro <thomas.munro@gmail.com>
Re: WIP: WAL prefetch (another approach) David Steele <david@pgmasters.net>
Re: WIP: WAL prefetch (another approach) Thomas Munro <thomas.munro@gmail.com>
Re: WIP: WAL prefetch (another approach) Dmitry Dolgov <9erthalion6@gmail.com>
Re: WIP: WAL prefetch (another approach) Thomas Munro <thomas.munro@gmail.com>
Re: WIP: WAL prefetch (another approach) Dmitry Dolgov <9erthalion6@gmail.com>
Re: WIP: WAL prefetch (another approach) Dmitry Dolgov <9erthalion6@gmail.com>
Re: WIP: WAL prefetch (another approach) Thomas Munro <thomas.munro@gmail.com>
Re: WIP: WAL prefetch (another approach) Alvaro Herrera <alvherre@2ndquadrant.com>
Re: WIP: WAL prefetch (another approach) Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: WIP: WAL prefetch (another approach) Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: WIP: WAL prefetch (another approach) Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: WIP: WAL prefetch (another approach) Thomas Munro <thomas.munro@gmail.com>
Re: WIP: WAL prefetch (another approach) Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: WIP: WAL prefetch (another approach) Stephen Frost <sfrost@snowman.net>
Re: WIP: WAL prefetch (another approach) Thomas Munro <thomas.munro@gmail.com>
Re: WIP: WAL prefetch (another approach) Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: WIP: WAL prefetch (another approach) Thomas Munro <thomas.munro@gmail.com>
Re: WIP: WAL prefetch (another approach) Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: WIP: WAL prefetch (another approach) Thomas Munro <thomas.munro@gmail.com>
Re: WIP: WAL prefetch (another approach) Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: WIP: WAL prefetch (another approach) Thomas Munro <thomas.munro@gmail.com>
Re: WIP: WAL prefetch (another approach) Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: WIP: WAL prefetch (another approach) Thomas Munro <thomas.munro@gmail.com>
Re: WIP: WAL prefetch (another approach) Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: WIP: WAL prefetch (another approach) Thomas Munro <thomas.munro@gmail.com>
Re: WIP: WAL prefetch (another approach) Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: WIP: WAL prefetch (another approach) Thomas Munro <thomas.munro@gmail.com>
Re: WIP: WAL prefetch (another approach) Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: WIP: WAL prefetch (another approach) Thomas Munro <thomas.munro@gmail.com>
Re: WIP: WAL prefetch (another approach) Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: WIP: WAL prefetch (another approach) Stephen Frost <sfrost@snowman.net>
Re: WIP: WAL prefetch (another approach) Thomas Munro <thomas.munro@gmail.com>
Re: WIP: WAL prefetch (another approach) Stephen Frost <sfrost@snowman.net>
Re: WIP: WAL prefetch (another approach) Thomas Munro <thomas.munro@gmail.com>
Re: WIP: WAL prefetch (another approach) Stephen Frost <sfrost@snowman.net>
Re: WIP: WAL prefetch (another approach) Andres Freund <andres@anarazel.de>
Re: WIP: WAL prefetch (another approach) Stephen Frost <sfrost@snowman.net>
Re: WIP: WAL prefetch (another approach) Thomas Munro <thomas.munro@gmail.com>
RE: WIP: WAL prefetch (another approach) Jakub Wartak <Jakub.Wartak@tomtom.com>
Re: WIP: WAL prefetch (another approach) Thomas Munro <thomas.munro@gmail.com>
Re: WIP: WAL prefetch (another approach) Andres Freund <andres@anarazel.de>
Re: WIP: WAL prefetch (another approach) Stephen Frost <sfrost@snowman.net>
Re: WIP: WAL prefetch (another approach) Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: WIP: WAL prefetch (another approach) Andres Freund <andres@anarazel.de>
Re: WIP: WAL prefetch (another approach) Stephen Frost <sfrost@snowman.net>
Re: WIP: WAL prefetch (another approach) Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: WIP: WAL prefetch (another approach) Stephen Frost <sfrost@snowman.net>
Re: WIP: WAL prefetch (another approach) Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: WIP: WAL prefetch (another approach) Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: WIP: WAL prefetch (another approach) Thomas Munro <thomas.munro@gmail.com>
RE: [EXTERNAL] Re: WIP: WAL prefetch (another approach) Sait Talha Nisanci <Sait.Nisanci@microsoft.com>
Re: [EXTERNAL] Re: WIP: WAL prefetch (another approach) Stephen Frost <sfrost@snowman.net>
RE: [EXTERNAL] Re: WIP: WAL prefetch (another approach) Sait Talha Nisanci <Sait.Nisanci@microsoft.com>
Re: [EXTERNAL] Re: WIP: WAL prefetch (another approach) Stephen Frost <sfrost@snowman.net>
Re: [EXTERNAL] Re: WIP: WAL prefetch (another approach) Andres Freund <andres@anarazel.de>
Re: [EXTERNAL] Re: WIP: WAL prefetch (another approach) Stephen Frost <sfrost@snowman.net>
Re: [EXTERNAL] Re: WIP: WAL prefetch (another approach) Robert Haas <robertmhaas@gmail.com>
Re: [EXTERNAL] Re: WIP: WAL prefetch (another approach) Stephen Frost <sfrost@snowman.net>
Re: [EXTERNAL] Re: WIP: WAL prefetch (another approach) Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: [EXTERNAL] Re: WIP: WAL prefetch (another approach) Stephen Frost <sfrost@snowman.net>
RE: [EXTERNAL] Re: WIP: WAL prefetch (another approach) Sait Talha Nisanci <Sait.Nisanci@microsoft.com>
Re: [EXTERNAL] Re: WIP: WAL prefetch (another approach) Robert Haas <robertmhaas@gmail.com>
Hi, 

Thank you for developing a great feature. I tested this feature and checked the documentation.
Currently, the documentation for the pg_stat_prefetch_recovery view is included in the description for the pg_stat_subscription view.

https://www.postgresql.org/docs/devel/monitoring-stats.html#MONITORING-PG-STAT-SUBSCRIPTION

It is also not displayed in the list of "28.2. The Statistics Collector".
https://www.postgresql.org/docs/devel/monitoring.html

The attached patch modifies the pg_stat_prefetch_recovery view to appear as a separate view.

Regards,
Noriyoshi Shinoda

-----Original Message-----
From: Thomas Munro [mailto:thomas.munro@gmail.com] 
Sent: Saturday, April 10, 2021 5:46 AM
To: Justin Pryzby 
Cc: Tomas Vondra ; Stephen Frost ; Andres Freund ; Jakub Wartak ; Alvaro Herrera ; Tomas Vondra ; Dmitry Dolgov <9erthalion6@gmail.com>; David Steele ; pgsql-hackers 
Subject: Re: WIP: WAL prefetch (another approach)

On Sat, Apr 10, 2021 at 8:37 AM Justin Pryzby  wrote:
> Did you see this?
> INVALID URI REMOVED
> 278MB0483490FEAC879DCA5ED583DD2739*40GV0P278MB0483.CHEP278.PROD.OUTLOO
> K.COM__;JQ!!NpxR!wcPrhiB2CaHRtywGoh9Ap0M-kH1m07hGI37-ycYRGCPgCqGs30lRS
> KicsXacduEXHxI$
>
> I meant to mail you so you could include it in the same commit, but 
> forgot until now.

Done, thanks.


В списке pgsql-hackers по дате отправления
От: Masahiko Sawada
Дата:
От: Craig Ringer
Дата:
FAQ