model-writtenrun 5221 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Reid Thompson reported that an idle PostgreSQL instance's autovacuum launcher grew to 42 MB over almost three days and supplied a patch restoring the caller's memory context after get_database_list() commits its internal transaction #1.
- Tom Lane reproduced the growth with autovacuum_naptime set to one second, confirmed that the patch kept memory consumption stable, and advocated backpatching to all supported branches because both callers expected a short-lived memory context #2.
- Andres Freund expressed agreement with the fix and backpatch discussion before the change landed #3.
- Tom Lane committed Reid's patch with only a shortened comment, retaining the context-restoration logic and backpatching the fix to all supported branches #1 1c1294be71.
- Michael Paquier thanked the participants for the quick fix and backpatch, closing the thread with the change landed and no outstanding work raised #4.