public inbox for [email protected]
help / color / mirror / Atom feedFrom: Tom Lane <[email protected]>
To: Dmitry O Litvintsev <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Seeing new stuff in log after upgrading from 11 to 15
Date: Wed, 15 May 2024 19:50:56 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <PH0PR09MB730858270F65D1E2CBBF6708B9EC2@PH0PR09MB7308.namprd09.prod.outlook.com>
References: <PH0PR09MB730858270F65D1E2CBBF6708B9EC2@PH0PR09MB7308.namprd09.prod.outlook.com>
Dmitry O Litvintsev <[email protected]> writes:
> After upgrade 11 -> 15 started to see these messages in hot standby log:
> < 2024-05-15 17:20:24.164 CDT 151879 > LOG: restartpoint complete: wrote 296338 buffers (28.3%); 0 WAL file(s) added, 134 removed, 0 recycled; write=1619.469 s, sync=0.022 s, total=1619.539 s; sync files=1492, longest=0.002 s, average=0.001 s; distance=2195446 kB, estimate=4171347 kB
> < 2024-05-15 17:20:24.164 CDT 151879 > LOG: recovery restart point at 17AB8/47000140
> < 2024-05-15 17:20:24.164 CDT 151879 > DETAIL: Last completed transaction was at log time 2024-05-15 17:20:24.138362-05.
> < 2024-05-15 17:20:24.167 CDT 151879 > LOG: restartpoint starting: wal
> while running 11 the log was almost empty, and I did not modify verbosity settings...
> Queston : are above harmless and just informational?
This is checkpoint logging, which is on by default now (a decision
I didn't particularly approve of). Feel free to set
"log_checkpoints = off" if you don't want it.
regards, tom lane
view thread (2+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Seeing new stuff in log after upgrading from 11 to 15
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox