Re: Cutting initdb's runtime (Perl question embedded)

From: Andres Freund <andres(at)anarazel(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Andreas Karlsson <andreas(at)proxel(dot)se>, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Cutting initdb's runtime (Perl question embedded)
Date: 2017-04-13 16:41:32
Message-ID: 20170413164132.3nhobp4z4wnnvhca@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2017-04-13 12:13:30 -0400, Tom Lane wrote:
> Andreas Karlsson <andreas(at)proxel(dot)se> writes:
> > Here is my proof of concept patch. It does basically the same thing as
> > Andres's patch except that it handles quoted values a bit better and
> > does not try to support anything other than the regproc type.
>
> > The patch speeds up initdb without fsync from 0.80 seconds to 0.55
> > seconds, which is a nice speedup, while adding a negligible amount of
> > extra work on compilation.
>
> I've pushed this with some mostly-cosmetic adjustments:

Cool. I wonder if we also should remove AtEOXact_CatCache()'s
cross-checks - the resowner replacement has been in place for a while,
and seems robust enough. They're now the biggest user of time.

- Andres

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2017-04-13 16:53:27 Re: Re: Query fails when SRFs are part of FROM clause (Commit id: 69f4b9c85f)
Previous Message Heikki Linnakangas 2017-04-13 16:37:33 Re: Letting the client choose the protocol to use during a SASL exchange