Horton

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

Andreas Karlsson <andreas@proxel.se>

View thread View on postgr.es
From: Andreas Karlsson <andreas@proxel.se>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-hackers@postgreSQL.org, Andres Freund <andres@anarazel.de>
Date: 2017-04-14T18:51:39Z
Lists: pgsql-hackers 
On 04/13/2017 06:13 PM, Tom Lane wrote:
> I've pushed this with some mostly-cosmetic adjustments:

Thanks! I like your adjustments.

> There's certainly lots more that could be done in the genbki code,
> but I think all we can justify at this stage of the development
> cycle is to get the low-hanging fruit for testing speedups.

Yeah, I also noticed that the genbki code seems to have gotten little 
love and that much more can be done here.

Andreas

Commits

  1. Attempt to identify system timezone by reading /etc/localtime symlink.

  2. Make sure to run one initdb TAP test with no TZ set

  3. Use one transaction while reading postgres.bki, not one per line.

  4. Move bootstrap-time lookup of regproc OIDs into genbki.pl.