| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Andres Freund <andres(at)anarazel(dot)de> |
| Cc: | Dagfinn Ilmari Mannsåker <ilmari(at)ilmari(dot)org>, 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-17 17:09:33 |
| Message-ID: | 7985.1492448973@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Andres Freund <andres(at)anarazel(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2017-04-17 17:12:23 | Re: extended stats not friendly towards ANALYZE with subset of columns |
| Previous Message | Andres Freund | 2017-04-17 16:53:15 | Re: Cutting initdb's runtime (Perl question embedded) |