Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pzzEO-0002Ab-Nv for pgsql-hackers@arkaria.postgresql.org; Fri, 19 May 2023 12:29:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pzzEN-0003rf-FT for pgsql-hackers@arkaria.postgresql.org; Fri, 19 May 2023 12:29:11 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pzzEN-0003rV-67 for pgsql-hackers@lists.postgresql.org; Fri, 19 May 2023 12:29:11 +0000 Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1pzzEJ-000inh-OY for pgsql-hackers@postgresql.org; Fri, 19 May 2023 12:29:10 +0000 Received: from bruce by momjian.us with local (Exim 4.94.2) (envelope-from ) id 1pzzEI-00BdZo-Pz; Fri, 19 May 2023 08:29:06 -0400 Date: Fri, 19 May 2023 08:29:06 -0400 From: Bruce Momjian To: "Drouvot, Bertrand" Cc: PostgreSQL-development Subject: Re: PG 16 draft release notes ready Message-ID: References: <890b2035-7bd0-c243-de7c-84809b35ffb0@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <890b2035-7bd0-c243-de7c-84809b35ffb0@gmail.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, May 19, 2023 at 09:49:18AM +0200, Drouvot, Bertrand wrote: > Thanks! > > " > This adds the function pg_log_standby_snapshot(). TEXT?: > " > > My proposal: > > This adds the function pg_log_standby_snapshot() to log details of the current snapshot > to WAL. If the primary is idle, the slot creation on a standby can take a while. > This function can be used on the primary to speed up the logical slot creation on > the standby. Yes, I got this concept from the commit message, but I am unclear on what is actually happening so I can clearly explain it. Slot creation on the standby needs a snapshot, and that is only created when there is activity, or happens periodically, and this forces it to happen, or something? And what snapshot is this? The current session's? -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.