Re: Create syscaches for pg_extension

From: Andrei Lepikhov <lepihov(at)gmail(dot)com>
To: Jelte Fennema-Nio <postgres(at)jeltef(dot)nl>
Cc: Michael Paquier <michael(at)paquier(dot)xyz>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Alexander Korotkov <aekorotkov(at)gmail(dot)com>
Subject: Re: Create syscaches for pg_extension
Date: 2024-09-05 20:03:09
Message-ID: 97f97cf2-d310-4cbc-9214-c8c2dd919998@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 5/9/2024 18:50, Jelte Fennema-Nio wrote:
> On Thu, 5 Sept 2024 at 15:41, Andrei Lepikhov <lepihov(at)gmail(dot)com> wrote:
>> It seems that the get_extension_oid routine was not modified when the
>> sys cache was introduced. What is the reason? It may be that this
>> routine is redundant now, but if not, and we want to hold the API that
>> extensions use, maybe we should rewrite it, too.
>> See the attachment proposing changes.
>
> It seems reasonable to make this function use the new syscache. I
> didn't change any existing code in my original patch, because I wanted
> to use the syscache APIs directly anyway and I didn't want to make the
> patch bigger than strictly necessary. But I totally understand that
> for many usages it's probably enough if the existing APIs are simply
> faster (on repeated calls). The patch looks fine. But I think
> get_extension_name and get_extension_schema should also be updated.
Thanks, see new patch in attachment.

--
regards, Andrei Lepikhov

Attachment Content-Type Size
0001-Lookup-an-extension-data-in-corresponding-syscache.patch text/plain 3.7 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Euler Taveira 2024-09-05 20:32:46 Re: Adding NOTICE for differences between estimated and actual rows
Previous Message Tom Lane 2024-09-05 18:45:34 Re: Add GiST support for mixed-width integer operators