pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andres Freund <andres@anarazel.de>
Cc: Dagfinn Ilmari Mannsåker <ilmari@ilmari.org>
Cc: Andreas Karlsson <andreas@proxel.se>
Cc: pgsql-hackers@postgreSQL.org
Subject: Re: Cutting initdb's runtime (Perl question embedded)
Date: Mon, 17 Apr 2017 13:09:33 -0400
Message-ID: <7985.1492448973@sss.pgh.pa.us> (raw)
In-Reply-To: <20170417165315.7jtyajt7unjp56ii@alap3.anarazel.de>
References: <30896.1492006367@sss.pgh.pa.us>
	<a15e94ac-c346-5816-69ae-ec6811e32af1@proxel.se>
	<972d541d-7285-53ff-ea71-dcbfd886570a@proxel.se>
	<6312.1492100010@sss.pgh.pa.us>
	<d8jpogbq8r1.fsf@dalvik.ping.uio.no>
	<20170417165315.7jtyajt7unjp56ii@alap3.anarazel.de>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>

Andres Freund <andres@anarazel.de> writes:
> On 2017-04-17 17:49:54 +0100, Dagfinn Ilmari Mannsåker wrote:
>> I threw Devel::NYTProf at it and picked some more low-hanging fruit.

> I'm a bit doubtful about improving the performance of genbki at the cost
> of any sort of complication - it's only executed during the actual
> build, not during initdb...  I don't see much point in doing things like
> 3) and 4), it's just not worth it imo.

Yeah, it's only run once per build, or probably even less often than that
considering we only re-run it when the input files change.  I could get
interested in another 20% reduction in initdb's time, but not genbki's.

			regards, tom lane


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers



view thread (52+ messages)  latest in thread

Message-ID: <7985.1492448973@sss.pgh.pa.us>
Permalink:  ../7985.1492448973@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/7985.1492448973@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: tgl@sss.pgh.pa.us, andres@anarazel.de, ilmari@ilmari.org, andreas@proxel.se
  Subject: Re: Cutting initdb's runtime (Perl question embedded)
  In-Reply-To: <7985.1492448973@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox