Re: New function to show index being vacuumed

2023-06-22 Thread Imseih (AWS), Sami
> I'm sorry for not having read (and not reading) the other thread yet, > but what was the reason we couldn't store that oid in a column in the > pg_s_p_vacuum-view? > Could you summarize the other solutions that were considered for this issue? Thanks for your feedback! The reason we cannot sti

Re: New function to show index being vacuumed

2023-06-22 Thread Matthias van de Meent
On Thu, 22 Jun 2023 at 16:45, Imseih (AWS), Sami wrote: > > Hi, > > [1] is a ready-for-committer enhancement to pg_stat_progress_vacuum which > exposes > the total number of indexes to vacuum and how many indexes have been vacuumed > in > the current vacuum cycle. > > To even further improve vis

New function to show index being vacuumed

2023-06-22 Thread Imseih (AWS), Sami
Hi, [1] is a ready-for-committer enhancement to pg_stat_progress_vacuum which exposes the total number of indexes to vacuum and how many indexes have been vacuumed in the current vacuum cycle. To even further improve visibility into index vacuuming, it would be beneficial to have a function cal