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

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

2025-06-10 Thread Andrew Johnson
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 Multixact membership exhaustion is an edge case that can cause write lockouts