Re: Replacing pg_depend PIN entries with a fixed range check

From: John Naylor <john(dot)naylor(at)enterprisedb(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Rushabh Lathia <rushabh(dot)lathia(at)gmail(dot)com>, Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>
Subject: Re: Replacing pg_depend PIN entries with a fixed range check
Date: 2021-07-14 20:10:26
Message-ID: CAFBsxsE7j=w-JSVB+D1XWDbTFiiRQFart9oYqW4AZ1SdP_izRA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Jul 14, 2021 at 3:34 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Hm, I'm not following? setup_depend runs in initdb, that is on the
> client side. It can't invoke backend-internal functions any other
> way than via SQL, AFAICS.

Ah, brainfade on my part.

I was also curious about the test case where Andres fixed a regression in
the parent thread [1], and there is a noticeable improvement (lowest of 10
measurements):

HEAD: 623ms
patch: 567ms

If no one else has anything, I think this is ready for commit.

[1]
https://www.postgresql.org/message-id/20210406043521.lopeo7bbigad3n6t%40alap3.anarazel.de

--
John Naylor
EDB: http://www.enterprisedb.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2021-07-14 20:28:13 Re: Quick tip on building pg with Visual Studio Build Tools 2019 + small patches
Previous Message Tom Lane 2021-07-14 19:43:47 Re: pg_upgrade does not upgrade pg_stat_statements properly