Re: Commit ab596105b55 - BRIN minmax-multi indexes

From: Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>
To: Rushabh Lathia <rushabh(dot)lathia(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, tomas(dot)vondra(at)postgresql(dot)org
Subject: Re: Commit ab596105b55 - BRIN minmax-multi indexes
Date: 2021-04-15 15:01:51
Message-ID: 796cf828-a54b-f041-c350-5fcc09613be7@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 4/15/21 4:29 PM, Rushabh Lathia wrote:
>
>
> On Thu, Apr 15, 2021 at 7:49 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us
> <mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us>> wrote:
>
> Rushabh Lathia <rushabh(dot)lathia(at)gmail(dot)com
> <mailto:rushabh(dot)lathia(at)gmail(dot)com>> writes:
> > Commit mentioned in the $subject changed the FirstBootstrapObjectId
> > (transam.h) from 12000 to 13000.  I was trying to understand the
> reason
> > behind this change, but was not able to gather that information.
> Also didn't
> > find anything in the commit message either.
>
> As of right now, genbki.pl <http://genbki.pl>'s OID counter reaches
> 12036, so it's
> pretty clear that 12000 no longer works.  (I have this figure in
> my head because I noted it while working on [1].)  13000 might
> well be an excessive jump though.  Do you have a concrete problem
> with it?
>

Yeah, the bump from 12000 to 13000 might be unnecessarily large. But
considering the bootstrap uses only about 1000 OIDs from the >=13000
range, I don't see this as a problem. Surely we can move the ranges in
the future, if needed?

>
> In EDB Advance Server, it has their own set of system objects.  Due
> to mentioned commit (where it changes the FirstBootstrapObjectId to 13000),
> now system objects exceeding the FirstNormalObjectId.  
>

I haven't checked what the EDBAS does exactly, but how could it hit
16384 because of custom catalogs? I haven't checked what exactly is
EDBAS doing, but surely it does not have thousands of catalogs, right?

It's OK to lower FirstBootstrapObjectId to e.g. 12500 during the merge,
if that solves the issue for EDBAS. As I said, those ranges are mostly
arbitrary anyway, and EDBAS already has catalogs differences.

regards

--
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2021-04-15 15:08:09 Re: TRUNCATE on foreign table
Previous Message Fujii Masao 2021-04-15 14:49:43 Re: TRUNCATE on foreign table