Hi, On 2023-09-01 14:59:57 +0200, Peter Eisentraut wrote: > On 01.09.23 14:37, Tom Lane wrote: > > Krishnakumar R <kksrcv...@gmail.com> writes: > > > This patch moves the pre-processing for tokens in the bki file from > > > initdb to bootstrap. With these changes the bki file will only be > > > opened once in bootstrap and parsing will be done by the bootstrap > > > parser. > > > > You haven't provided any iota of evidence why this would be an > > improvement. > > I had played with similar ideas in the past, because it would shave some > time of initdb, which would accumulate noticeably over a full test run. > > But now with the initdb caching mechanism, I wonder whether this is still > needed.
I think it's still relevant - it's not just our own test infrastructure that runs a lot of initdbs, it's also lots of projects using postgres. The main reason I'd like to move this infrastructure to the backend is that I really would like to get rid of single user mode. It adds complications all over, it's barely tested, pointlessly hard to use. I wrote a rough prototype of that a while back: https://postgr.es/m/20220220214439.bhc35hhbaub6dush%40alap3.anarazel.de Greetings, Andres Freund
