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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] Cutting initdb's runtime (Perl question embedded)
Дата
Msg-id 7985.1492448973@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] Cutting initdb's runtime (Perl question embedded)  (Andres Freund <andres@anarazel.de>)
Ответы Re: [HACKERS] Cutting initdb's runtime (Perl question embedded)
Список pgsql-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



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: [HACKERS] Cutting initdb's runtime (Perl question embedded)
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: [HACKERS] extended stats not friendly towards ANALYZE withsubset of columns