On Thu, Nov 4, 2021 at 10:50 PM Fujii Masao <masao.fu...@oss.nttdata.com> wrote: > > On 2021/11/05 0:04, Robert Haas wrote: > > On Thu, Nov 4, 2021 at 10:59 AM Bharath Rupireddy > > <bharath.rupireddyforpostg...@gmail.com> wrote: > >> With log_checkpoints=on, the "./initdb -D data" generates few > >> checkpoints logs [1]. I hope this is okay as it's a one-time thing per > >> database cluster. Thoughts? > > > > I think you should arrange to suppress that output. > > +1
Thanks. I did that. > > I didn't spot any other problems on a quick read-through. > > -bool log_checkpoints = false; > +bool log_checkpoints = true; > > It's better to initialize the global variable Log_autovacuum_min_duration > with 600000 like the above change? I missed it. Added now. Please review the attached v2 patch. Regards, Bharath Rupireddy.
v2-0001-set-log_checkpoints-on-log_autovacuum_min_duratio.patch
Description: Binary data