Postgres Pro
Downloads
Home   >   mailing lists

Thread: Create syscaches for pg_extension

Create syscaches for pg_extension

From
Jelte Fennema-Nio
Date:
Shared libraries of extensions might want to invalidate or update their
own caches whenever a CREATE/ALTER/DROP EXTENSION command is run for
their extension (in any backend). Right now this is non-trivial to do
correctly and efficiently. But if the extension catalog was part of a
syscache this could simply be done by registering an callback using
CacheRegisterSyscacheCallback for the relevant syscache.

This change is only made to make the lives of extension authors easier.
The performance impact of this change should be negligible, since
updates to pg_extension are very rare.
Attachment

Re: Create syscaches for pg_extension

From
Pavel Stehule
Date:


út 13. 8. 2024 v 16:13 odesílatel Jelte Fennema-Nio <postgres@jeltef.nl> napsal:
Shared libraries of extensions might want to invalidate or update their
own caches whenever a CREATE/ALTER/DROP EXTENSION command is run for
their extension (in any backend). Right now this is non-trivial to do
correctly and efficiently. But if the extension catalog was part of a
syscache this could simply be done by registering an callback using
CacheRegisterSyscacheCallback for the relevant syscache.

This change is only made to make the lives of extension authors easier.
The performance impact of this change should be negligible, since
updates to pg_extension are very rare.

+1

Pavel

Re: Create syscaches for pg_extension

From
Alexander Korotkov
Date:
On Tue, Aug 13, 2024 at 5:23 PM Pavel Stehule <pavel.stehule@gmail.com> wrote:
> út 13. 8. 2024 v 16:13 odesílatel Jelte Fennema-Nio <postgres@jeltef.nl> napsal:
>>
>> Shared libraries of extensions might want to invalidate or update their
>> own caches whenever a CREATE/ALTER/DROP EXTENSION command is run for
>> their extension (in any backend). Right now this is non-trivial to do
>> correctly and efficiently. But if the extension catalog was part of a
>> syscache this could simply be done by registering an callback using
>> CacheRegisterSyscacheCallback for the relevant syscache.
>>
>> This change is only made to make the lives of extension authors easier.
>> The performance impact of this change should be negligible, since
>> updates to pg_extension are very rare.
>
>
> +1

+1 from me too

------
Regards,
Alexander Korotkov
Supabase