Re: Using a single standalone-backend run in initdb (was Re: Bootstrap DATA is a pita)

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: Using a single standalone-backend run in initdb (was Re: Bootstrap DATA is a pita)
Дата
Msg-id
23778.1449967936@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
Re: Bootstrap DATA is a pita Caleb Welton <cwelton@pivotal.io>
Re: Bootstrap DATA is a pita Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Bootstrap DATA is a pita Tom Lane <tgl@sss.pgh.pa.us>
Re: Bootstrap DATA is a pita Mark Dilger <hornschnorter@gmail.com>
Re: Bootstrap DATA is a pita Tom Lane <tgl@sss.pgh.pa.us>
Re: Bootstrap DATA is a pita Mark Dilger <hornschnorter@gmail.com>
Re: Bootstrap DATA is a pita Tom Lane <tgl@sss.pgh.pa.us>
Re: Bootstrap DATA is a pita Mark Dilger <hornschnorter@gmail.com>
Re: Bootstrap DATA is a pita Tom Lane <tgl@sss.pgh.pa.us>
Re: Bootstrap DATA is a pita Andres Freund <andres@anarazel.de>
Re: Bootstrap DATA is a pita Tom Lane <tgl@sss.pgh.pa.us>
Re: Bootstrap DATA is a pita Caleb Welton <cwelton@pivotal.io>
Re: Bootstrap DATA is a pita Tom Lane <tgl@sss.pgh.pa.us>
Re: Bootstrap DATA is a pita Andres Freund <andres@anarazel.de>
Re: Bootstrap DATA is a pita Caleb Welton <cwelton@pivotal.io>
Re: Bootstrap DATA is a pita Mark Dilger <hornschnorter@gmail.com>
Re: Bootstrap DATA is a pita Tom Lane <tgl@sss.pgh.pa.us>
Re: Bootstrap DATA is a pita Andres Freund <andres@anarazel.de>
Using a single standalone-backend run in initdb (was Re: Bootstrap DATA is a pita) Tom Lane <tgl@sss.pgh.pa.us>
Re: Using a single standalone-backend run in initdb (was Re: Bootstrap DATA is a pita) Andres Freund <andres@anarazel.de>
Re: Using a single standalone-backend run in initdb (was Re: Bootstrap DATA is a pita) Tom Lane <tgl@sss.pgh.pa.us>
Re: Using a single standalone-backend run in initdb (was Re: Bootstrap DATA is a pita) Tom Lane <tgl@sss.pgh.pa.us>
Re: Using a single standalone-backend run in initdb (was Re: Bootstrap DATA is a pita) Joe Conway <mail@joeconway.com>
Re: Using a single standalone-backend run in initdb (was Re: Bootstrap DATA is a pita) Tom Lane <tgl@sss.pgh.pa.us>
Re: Using a single standalone-backend run in initdb (was Re: Bootstrap DATA is a pita) Mark Dilger <hornschnorter@gmail.com>
Re: Using a single standalone-backend run in initdb (was Re: Bootstrap DATA is a pita) Tom Lane <tgl@sss.pgh.pa.us>
Re: Using a single standalone-backend run in initdb (was Re: Bootstrap DATA is a pita) Mark Dilger <hornschnorter@gmail.com>
Re: Using a single standalone-backend run in initdb (was Re: Bootstrap DATA is a pita) Tom Lane <tgl@sss.pgh.pa.us>
Re: Using a single standalone-backend run in initdb (was Re: Bootstrap DATA is a pita) Craig Ringer <craig@2ndquadrant.com>
Re: Using a single standalone-backend run in initdb (was Re: Bootstrap DATA is a pita) Tom Lane <tgl@sss.pgh.pa.us>
Re: Bootstrap DATA is a pita Caleb Welton <cwelton@pivotal.io>
Re: Bootstrap DATA is a pita Caleb Welton <cwelton@pivotal.io>
Andres Freund  writes:
> That's cool too. Besides processing the .bki files, and there largely
> reg*_in, the many restarts are the most expensive parts of initdb.

BTW, in case anyone is doubting it, I did a little bit of "perf" tracing
and confirmed Andres' comment here: more than 50% of the runtime of the
bootstrap phase is eaten by the pg_proc seqscans performed by regprocin.
There's nothing else amounting to more than a few percent, so basically
nothing else in bootstrap is worth optimizing before we fix that.
		regards, tom lane


В списке pgsql-hackers по дате отправления
От: David Fetter
Дата:
От: Tom Lane
Дата:
Сообщение: Re: [PATCH] PostGIS Doc Urls
FAQ