Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s7OOk-005SXL-8s for pgsql-general@arkaria.postgresql.org; Wed, 15 May 2024 23:51:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1s7OOk-00AhTl-7l for pgsql-general@arkaria.postgresql.org; Wed, 15 May 2024 23:51:02 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s7OOj-00AhTc-TI for pgsql-general@lists.postgresql.org; Wed, 15 May 2024 23:51:01 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s7OOh-000PTm-HN for pgsql-general@lists.postgresql.org; Wed, 15 May 2024 23:51:00 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 44FNoumX1921892; Wed, 15 May 2024 19:50:56 -0400 From: Tom Lane To: Dmitry O Litvintsev cc: "pgsql-general@lists.postgresql.org" Subject: Re: Seeing new stuff in log after upgrading from 11 to 15 In-reply-to: References: Comments: In-reply-to Dmitry O Litvintsev message dated "Wed, 15 May 2024 23:27:52 -0000" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <1921890.1715817056.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Wed, 15 May 2024 19:50:56 -0400 Message-ID: <1921891.1715817056@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Dmitry O Litvintsev 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: wro= te 296338 buffers (28.3%); 0 WAL file(s) added, 134 removed, 0 recycled; w= rite=3D1619.469 s, sync=3D0.022 s, total=3D1619.539 s; sync files=3D1492, = longest=3D0.002 s, average=3D0.001 s; distance=3D2195446 kB, estimate=3D41= 71347 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 transact= ion 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 verbosit= y 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 =3D off" if you don't want it. regards, tom lane