Horton

Re: Design of pg_stat_subscription_workers vs pgstats

Robert Haas <robertmhaas@gmail.com>

View thread View on postgr.es
From: Robert Haas <robertmhaas@gmail.com>
To: Andres Freund <andres@anarazel.de>
Cc: Masahiko Sawada <sawada.mshk@gmail.com>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>, Amit Kapila <amit.kapila16@gmail.com>
Date: 2022-02-15T18:31:44Z
Lists: pgsql-hackers 
On Thu, Jan 27, 2022 at 12:46 AM Andres Freund <andres@anarazel.de> wrote:
> Only if either the user wants to drop all stats, or somehow knows the oids of
> already dropped tables...

If it's really true that we can end up storing data for dropped
objects, I think that's not acceptable and needs to be fixed.

I don't currently understand the other issues on this thread well
enough to have a clear opinion on them.

-- 
Robert Haas
EDB: http://www.enterprisedb.com

Commits

  1. Reconsider pg_stat_subscription_workers view.

  2. Add a view to show the stats of subscription workers.