Re: Why does bootstrap and later initdb stages happen via client?

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Why does bootstrap and later initdb stages happen via client?
Дата
Msg-id FA028E6B-AAD6-4AEE-8FD7-6CD1ABA40123@anarazel.de
обсуждение исходный текст
Ответ на Re: Why does bootstrap and later initdb stages happen via client?  (Andrew Dunstan <andrew@dunslane.net>)
Ответы Re: Why does bootstrap and later initdb stages happen via client?  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers
Hi,

On September 8, 2021 1:24:00 PM PDT, Andrew Dunstan <andrew@dunslane.net> wrote:
>
>On 9/8/21 3:07 PM, Andres Freund wrote:
>> There of course is historical raisins for things happening in initdb - the
>> setup logic didn't use to be C. But now that it is C, it seems a bit absurd to
>> read bootstrap data in initdb, write the data to a pipe, and then read it
>> again in the backend. It for sure doesn't make things faster.
>
>
>I guess the downside would be that we'd need to teach the backend how to
>do more stuff that only needs to be done once per cluster, and then that
>code would be dead space for the rest of the lifetime of the cluster.
>
>
>Maybe the difference is sufficiently small that it doesn't matter.

Unused code doesn't itself cost much - the OS won't even page it in. And disk space wise, there's not much difference
betweencode in initdb and code in postgres. It's callsites to the code that can be problematic. But there were already
payingthe price via --boot and a fair number of if (bootstrap) blocks. 

Regards,

Andres
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [PATCH] support tab-completion for single quote input with equal sign
Следующее
От: Jacob Champion
Дата:
Сообщение: Re: [PATCH] support tab-completion for single quote input with equal sign