Re: Bootstrap DATA is a pita - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Bootstrap DATA is a pita
Date
Msg-id 20151211235544.GP14789@awork2.anarazel.de
Whole thread Raw
In response to Re: Bootstrap DATA is a pita  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 2015-12-11 18:12:16 -0500, Tom Lane wrote:
> I think what Mark is proposing is to do the lookups while preparing the
> .bki file, which would eliminate the circularity ... at the cost of having
> to, essentially, reimplement regprocedure_in and friends in Perl.

FWIW, I did that, when this came up last. Rather interesting, because it
leads to rather noticeable speedups - currently initdb spents a
significant amount of its time doing reproc lookups. Especially
interesting because at that stage we're largely not using indexes yet, IIRC.


Andres



pgsql-hackers by date:

Previous
From: Mark Dilger
Date:
Subject: Re: Bootstrap DATA is a pita
Next
From: Jim Nasby
Date:
Subject: Re: Add IS (NOT) DISTINCT to subquery_Op