Re: Add index scan progress to pg_stat_progress_vacuum
Andrei Lepikhov <a.lepikhov@postgrespro.ru>
From: Andrey Lepikhov <a.lepikhov@postgrespro.ru>
To: Peter Geoghegan <pg@bowt.ie>, "Imseih (AWS), Sami" <simseih@amazon.com>
Cc: "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2021-12-23T10:49:59Z
Lists: pgsql-hackers
On 21/12/2021 00:05, Peter Geoghegan wrote: > * Some index AMs don't work like nbtree and GiST in that they cannot > do their scan sequentially -- they have to do something like a > logical/keyspace order scan instead, which is *totally* different to > heapam (not just a bit different). There is no telling how many times > each page will be accessed in these other index AMs, and in what > order, even under optimal conditions. We should arguably not even try > to provide any granular progress information here, since it'll > probably be too messy. Maybe we could add callbacks into AM interface for send/receive/representation implementation of progress? So AM would define a set of parameters to send into stat collector and show to users. -- regards, Andrey Lepikhov Postgres Professional
Commits
-
Report index vacuum progress.
- 46ebdfe164c6 17.0 landed
-
Add new parallel message type to progress reporting.
- f1889729dd3a 17.0 landed
-
Remove MaxBackends variable in favor of GetMaxBackends() function.
- aa64f23b0292 15.0 cited