Re: Server won't start with fallback setting by initdb.
От
Michael Paquier
Тема
Re: Server won't start with fallback setting by initdb.
Дата
Msg-id
20180212132815.GB18625@paquier.xyz
Ответ на
Server won't start with fallback setting by initdb. (Kyotaro HORIGUCHI)
Список
Дерево обсуждения
Server won't start with fallback setting by initdb. Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: Server won't start with fallback setting by initdb. Michael Paquier <michael@paquier.xyz>
Re: Server won't start with fallback setting by initdb. Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: Server won't start with fallback setting by initdb. Michael Paquier <michael@paquier.xyz>
Re: Server won't start with fallback setting by initdb. Robert Haas <robertmhaas@gmail.com>
Re: Server won't start with fallback setting by initdb. Tom Lane <tgl@sss.pgh.pa.us>
Re: Server won't start with fallback setting by initdb. Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Server won't start with fallback setting by initdb. Tom Lane <tgl@sss.pgh.pa.us>
Re: Server won't start with fallback setting by initdb. Stephen Frost <sfrost@snowman.net>
Re: Server won't start with fallback setting by initdb. Robert Haas <robertmhaas@gmail.com>
Re: Server won't start with fallback setting by initdb. Tom Lane <tgl@sss.pgh.pa.us>
Re: Server won't start with fallback setting by initdb. Michael Paquier <michael@paquier.xyz>
Re: Server won't start with fallback setting by initdb. Robert Haas <robertmhaas@gmail.com>
Re: Server won't start with fallback setting by initdb. Tom Lane <tgl@sss.pgh.pa.us>
Re: Server won't start with fallback setting by initdb. Michael Paquier <michael@paquier.xyz>
Re: Server won't start with fallback setting by initdb. Tom Lane <tgl@sss.pgh.pa.us>
Re: Server won't start with fallback setting by initdb. Tom Lane <tgl@sss.pgh.pa.us>
On Fri, Feb 09, 2018 at 05:08:23PM +0900, Kyotaro HORIGUCHI wrote: > > postgres: max_wal_senders must be less than max_connections > > I think that we can safely increase the fallback value to 20 with > which regtests are known not to fail. I believe that is > preferable than explicitly reducing max_wal_senders in the > generated config file. I confirmed that tegtest won't fail with > the value. (Except with permanent failure of dynamic shared > memory) I would vote for just removing the minimum check at 10 connections as you do. It is not worth the code complication in initdb to decrease max_wal_senders if max_connections is set to 10, which does not happen even on definitely-not-decent hardware of those days like a RPI (memories from my hamster, RIP, which set max_connections to 100). -- Michael
В списке pgsql-hackers по дате отправления