Dear hackers,
This is a follow-up thread of [1]. I think it could be considered for
PG19 but let me share now.
Background
==========
Currently, all relsync cache entries would be discarded when the pg_namespace is
modified. This mechanism works well but is sometimes not efficient.
Theoretically, it is enough to invalidate entries which it belongs to the related
schema.
Patch overview
==============
Attached patch adds a new attribute for storing the hash value for pg_namespace.oid.
It would be set when the entry is created and used for the new syscache callback
function to check whether the entry is related.
At least this patch could pass tests on my env.
[1]:
https://www.postgresql.org/message-id/flat/OSCPR01MB14966C09AA201EFFA706576A7F5C92%40OSCPR01MB14966.jpnprd01.prod.outlook.com
Best regards,
Hayato Kuroda
FUJITSU LIMITED
