On Tue, 11 Mar 2025 at 14:37, Naga Appani <nagn...@gmail.com> wrote: > > > > On Mon, Mar 10, 2025 at 10:43 AM Naga Appani <nagn...@gmail.com> wrote: >> >> Hi, >>
Hi > ================= > Proposal > ================= > The internal ReadMultiXactCounts() function, implemented in multixact.c, > directly calculates the number of MultiXact members by reading live state > from shared memory. This approach avoids the performance issues of the > current filesystem-based estimation methods. This proposal looks sane. It is indeed helpful to keep an eye out for multixact usage in systems that are heavily loaded. > By exposing ReadMultiXactCounts() for external use, we can provide PostgreSQL > users with an efficient way to monitor MultiXact member usage. This could be > particularly useful for integrating with tools like Amazon RDS Performance > Insights and Amazon CloudWatch to provide enhanced database insights and > proactive managed monitoring for users. > > Please let me know if this approach is acceptable, so I’ll go ahead and > submit a patch. Let's give it a try! -- Best regards, Kirill Reshke
