Re: [PATCH v1] Add pg_stat_multixact view for multixact membership usage monitoring

2025-08-01 Thread Ashutosh Bapat
On Sun, Jun 15, 2025 at 6:21 AM Andrew Johnson wrote: > > To address your other concerns: > > > Since these counters are global, not aggregatable per backend > > I understand this perspective, though I'd suggest that PostgreSQL > already uses the pgstats pattern for similar global metrics, such a

Re: [PATCH v1] Add pg_stat_multixact view for multixact membership usage monitoring

2025-06-10 Thread Naga Appani
On Tue, Jun 10, 2025 at 11:40 AM Andrew Johnson wrote: > > Hi Naga, > > Thank you for the thoughtful feedback and for driving attention to > this issue. I appreciate you taking the time to review my patch. > > You raise some good points about the trade-offs between a lightweight > function and the

Re: [PATCH v1] Add pg_stat_multixact view for multixact membership usage monitoring

2025-06-10 Thread Andrew Johnson
Hi Naga, Thank you for the thoughtful feedback and for driving attention to this issue. I appreciate you taking the time to review my patch. You raise some good points about the trade-offs between a lightweight function and the pgstat infrastructure. I actually think both approaches have merit fo

Re: [PATCH v1] Add pg_stat_multixact view for multixact membership usage monitoring

2025-06-10 Thread Naga Appani
On Tue, Jun 10, 2025 at 9:40 AM Andrew Johnson wrote: > > Hello hackers, > > I'd like to propose adding a new view named "pg_stat_multixact" to > expose multixact member usage. This addresses a major monitoring gap > that ultimately led to a production outage at Metronome [1]. > > Problem > Multix