Re: Bootstrap DATA is a pita

From: Andres Freund <andres(at)anarazel(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Caleb Welton <cwelton(at)pivotal(dot)io>, Mark Dilger <hornschnorter(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Bootstrap DATA is a pita
Date: 2015-12-11 23:55:44
Message-ID: 20151211235544.GP14789@awork2.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2015-12-12 00:11:05 Re: pgsql: pg_rewind: Don't error if the two clusters are already on the sa
Previous Message Peter Eisentraut 2015-12-11 23:33:26 pgsql: pg_rewind: Don't error if the two clusters are already on the sa