MIME-Version: 1.0
From: Fujii Masao <masao.fujii@gmail.com>
Date: Sat, 28 Feb 2026 01:25:12 +0900
Message-ID: <CAHGQGwHO05JaUpgKF8FBDmPdBUJsK22axRRcgmAUc2Jyi8OK8g@mail.gmail.com>
Subject: Release postmaster working memory context in slotsync worker
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Content-Type: multipart/mixed; boundary="000000000000273b6d064bd0af01"
Archived-At: <https://www.postgresql.org/message-id/CAHGQGwHO05JaUpgKF8FBDmPdBUJsK22axRRcgmAUc2Jyi8OK8g%40mail.gmail.com>
Precedence: bulk

--000000000000273b6d064bd0af01
Content-Type: text/plain; charset="UTF-8"

Hi,

Child processes do not need the postmaster's working memory context and
release it at the start of their main function. However, the slotsync worker
appears to have missed this step.

To avoid this unnecessary memory usage, I'd like to propose that the slotsync
worker release the postmaster's working memory context at startup.
A patch is attached.

Currently, pg_log_backend_memory_contexts() reports the following
postmaster-related memory contexts in the slotsync worker:

    LOG:  level: 2; Postmaster: 21984 total in 2 blocks; 5600 free (7
chunks); 16384 used
    LOG:  level: 3; ident parser context: 1024 total in 1 blocks; 784
free (0 chunks); 240 used
    LOG:  level: 3; hba parser context: 25600 total in 6 blocks; 9864
free (11 chunks); 15736 used

With the attached patch, these contexts are no longer present.

Regards,

-- 
Fujii Masao

--000000000000273b6d064bd0af01
Content-Type: application/octet-stream; 
	name="v1-0001-Release-postmaster-working-memory-context-in-slot.patch"
Content-Disposition: attachment; 
	filename="v1-0001-Release-postmaster-working-memory-context-in-slot.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_mm53s2hy0>
X-Attachment-Id: f_mm53s2hy0

RnJvbSBjNDBjMjMxYTQ1MDc4YzhmNzQ5YjIwMGZiMDM2YjQ3MDA1MDllZmJkIE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBGdWppaSBNYXNhbyA8ZnVqaWlAcG9zdGdyZXNxbC5vcmc+CkRh
dGU6IFNhdCwgMjggRmViIDIwMjYgMDA6NTA6MTEgKzA5MDAKU3ViamVjdDogW1BBVENIIHYxXSBS
ZWxlYXNlIHBvc3RtYXN0ZXIgd29ya2luZyBtZW1vcnkgY29udGV4dCBpbiBzbG90c3luYwogd29y
a2VyLgoKQ2hpbGQgcHJvY2Vzc2VzIGRvIG5vdCBuZWVkIHRoZSBwb3N0bWFzdGVyJ3Mgd29ya2lu
ZyBtZW1vcnkgY29udGV4dCBhbmQKbm9ybWFsbHkgcmVsZWFzZSBpdCBhdCB0aGUgc3RhcnQgb2Yg
dGhlaXIgbWFpbiBlbnRyeSBwb2ludC4gSG93ZXZlciwKdGhlIHNsb3RzeW5jIHdvcmtlciBmb3Jn
b3QgdG8gZG8gc28uCgpUaGlzIGNvbW1pdCBtYWtlcyB0aGUgc2xvdHN5bmMgd29ya2VyIHJlbGVh
c2UgdGhlIHBvc3RtYXN0ZXIncyB3b3JraW5nIG1lbW9yeQpjb250ZXh0IGF0IHN0YXJ0dXAsIGF2
b2lkaW5nIHVubmVjZXNzYXJ5IG1lbW9yeSB1c2FnZSBpbiB0aGF0IHByb2Nlc3MuCi0tLQogc3Jj
L2JhY2tlbmQvcmVwbGljYXRpb24vbG9naWNhbC9zbG90c3luYy5jIHwgNyArKysrKysrCiAxIGZp
bGUgY2hhbmdlZCwgNyBpbnNlcnRpb25zKCspCgpkaWZmIC0tZ2l0IGEvc3JjL2JhY2tlbmQvcmVw
bGljYXRpb24vbG9naWNhbC9zbG90c3luYy5jIGIvc3JjL2JhY2tlbmQvcmVwbGljYXRpb24vbG9n
aWNhbC9zbG90c3luYy5jCmluZGV4IDA2MmEwOGNjYjg4Li40YzA1ZDFhOThkYiAxMDA2NDQKLS0t
IGEvc3JjL2JhY2tlbmQvcmVwbGljYXRpb24vbG9naWNhbC9zbG90c3luYy5jCisrKyBiL3NyYy9i
YWNrZW5kL3JlcGxpY2F0aW9uL2xvZ2ljYWwvc2xvdHN5bmMuYwpAQCAtMTQ4MCw2ICsxNDgwLDEz
IEBAIFJlcGxTbG90U3luY1dvcmtlck1haW4oY29uc3Qgdm9pZCAqc3RhcnR1cF9kYXRhLCBzaXpl
X3Qgc3RhcnR1cF9kYXRhX2xlbikKIAogCUFzc2VydChzdGFydHVwX2RhdGFfbGVuID09IDApOwog
CisJLyogUmVsZWFzZSBwb3N0bWFzdGVyJ3Mgd29ya2luZyBtZW1vcnkgY29udGV4dCAqLworCWlm
IChQb3N0bWFzdGVyQ29udGV4dCkKKwl7CisJCU1lbW9yeUNvbnRleHREZWxldGUoUG9zdG1hc3Rl
ckNvbnRleHQpOworCQlQb3N0bWFzdGVyQ29udGV4dCA9IE5VTEw7CisJfQorCiAJaW5pdF9wc19k
aXNwbGF5KE5VTEwpOwogCiAJQXNzZXJ0KEdldFByb2Nlc3NpbmdNb2RlKCkgPT0gSW5pdFByb2Nl
c3NpbmcpOwotLSAKMi41MS4yCgo=
--000000000000273b6d064bd0af01--