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
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
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
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