Re: Enhancing Memory Context Statistics Reporting
Fujii Masao <masao.fujii@oss.nttdata.com>
From: Fujii Masao <masao.fujii@oss.nttdata.com>
To: Daniel Gustafsson <daniel@yesql.se>
Cc: Rahila Syed <rahilasyed90@gmail.com>, Andres Freund <andres@anarazel.de>,
PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2025-04-08T23:28:09Z
Lists: pgsql-hackers
On 2025/04/09 6:27, Daniel Gustafsson wrote: >> On 8 Apr 2025, at 18:41, Fujii Masao <masao.fujii@oss.nttdata.com> wrote: > >> I noticed that the third argument of pg_get_process_memory_contexts() is named >> "retries" in pg_proc.dat, while the documentation refers to it as "timeout". > > I've committed this patch as it was obviously correct, thanks! Thanks a lot! Since pg_proc.dat was modified, do we need to bump the catalog version? >> Also, as I mentioned earlier, I encountered an issue when calling >> pg_get_process_memory_contexts() on the PID of a backend that had just >> encountered an error but hadn't finished rolling back. It led to >> the following situation: > > I reconfirmed that the bugfix that Rahila shared in [0] fixes this issue (and > will fix others like it, as it's not related to this patch in particular but is > a bug in DSM attaching). My plan is to take that for a more thorough review > and test tomorrow and see how far it can be safely backpatched. Thanks for > bringing this up, sorry about it getting a bit lost among all the emails. Appreciate your work on this! Regards, -- Fujii Masao Advanced Computing Technology Center Research and Development Headquarters NTT DATA CORPORATION
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Cross-check lists of built-in LWLock tranches.
- 2047ad068139 19 (unreleased) cited
-
Convert strncpy to strlcpy
- 45e7e8ca9e93 18.0 landed
-
Typo and doc fixups for memory context reporting
- f8c115a6cb65 18.0 landed
-
Add missing string terminator
- d2a1ed1727a8 18.0 landed
-
Rename argument in pg_get_process_memory_contexts().
- c57971034e69 18.0 landed
-
Add function to get memory context stats for processes
- 042a66291b04 18.0 landed