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 1lgSCl-0001UP-Uw for pgsql-hackers@arkaria.postgresql.org; Tue, 11 May 2021 13:13:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lgSCk-0005BF-N8 for pgsql-hackers@arkaria.postgresql.org; Tue, 11 May 2021 13:13:42 +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 1lgSCk-0005B7-F8 for pgsql-hackers@lists.postgresql.org; Tue, 11 May 2021 13:13:42 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lgSCg-00053j-ED for pgsql-hackers@postgresql.org; Tue, 11 May 2021 13:13:42 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Content-Type:In-Reply-To:MIME-Version:Date: Message-ID:From:References:Cc:To:Subject:Sender:Reply-To: Content-Transfer-Encoding:Content-ID:Content-Description; bh=Q2+RWOUcDWU+YoA1LJfET7JqbcCHu2lI37Y5vIYsN6o=; b=zwiLsCUjc5k2weaR2/HhJigp8H ZpYAz/yKhOO+VdwyFIzwY0/2vSZpJ+sNAZ64YVigZrE5qXXc/k57BdnwAW4qGLU0v9kDm64RlOQVh KewvxDUayHWXWGk4QFuNziLXKaZqMzEzE4VhvuVvZNCLR0AcEpOSj8r8U+OdCb92oYcvq/+JUHeYf O+72qiiKQ8GGU2IzhNe7qWJfpdTkzfx8t6VRagwhp4gcOnQRXcnBkdyL32pLR6fNYq+Hy9AEIUsgK Emg171sGzyR4oi3ApOVG0Fba0G9mgBP9T3FTd030AxI4GvKL5tj7mu0ANB3ZhNWbitY+h8XHR/n7X oxRAokWQ==; Received: from [70.19.69.80] (helo=[192.168.1.153]) by meldrar.postgresql.org with esmtpsa (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lgSCe-0005Z8-34; Tue, 11 May 2021 13:13:38 +0000 Subject: Re: PG 14 release notes, first draft To: Amit Kapila , Justin Pryzby Cc: Bruce Momjian , pgsql-hackers References: <20210510060308.GC6088@momjian.us> <20210510140005.GB27406@telsasoft.com> From: "Jonathan S. Katz" Message-ID: <97f6b32d-8c48-5656-b1ce-a3c4de8d6bf3@postgresql.org> Date: Tue, 11 May 2021 09:13:31 -0400 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:78.0) Gecko/20100101 Thunderbird/78.10.1 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="o8oikmdwaQk7QY26mLnnLo1r6Nq1Xc4V6" X-Host-Lookup-Failed: Reverse DNS lookup failed for 70.19.69.80 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --o8oikmdwaQk7QY26mLnnLo1r6Nq1Xc4V6 Content-Type: multipart/mixed; boundary="6RSNlptif2zCT3JhsnPrsXohMvnXvSkGm"; protected-headers="v1" From: "Jonathan S. Katz" To: Amit Kapila , Justin Pryzby Cc: Bruce Momjian , pgsql-hackers Message-ID: <97f6b32d-8c48-5656-b1ce-a3c4de8d6bf3@postgresql.org> Subject: Re: PG 14 release notes, first draft References: <20210510060308.GC6088@momjian.us> <20210510140005.GB27406@telsasoft.com> In-Reply-To: --6RSNlptif2zCT3JhsnPrsXohMvnXvSkGm Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: quoted-printable First Bruce, thank you for compiling the release notes draft. Comments inline: On 5/10/21 11:56 PM, Amit Kapila wrote: > On Mon, May 10, 2021 at 7:30 PM Justin Pryzby wr= ote: >> >> Can these be merged: >> Allow logical replication to stream long transactions to standbys (Di= lip Kumar, Tomas Vondra, Amit Kapila, Nikhil Sontakke) >> Improve the logical replication API to allow streaming large in-progr= ess transactions (Tomas Vondra, Dilip Kumar, Amit Kapila) >> >=20 > I think we should merge the below two: > Add support for streaming to built-in logical replication (Vondra, > Dilip Kumar, Amit Kapila, Ajin Cherian, Nikhil Sontakke, Stas Kelvich) >=20 > Allow logical replication to stream long transactions to standbys > (Dilip Kumar, Tomas Vondra, Amit Kapila, Nikhil Sontakke) >=20 > and say something like: > Allow logical replication to stream long in-progress transactions to st= andbys > Previously transactions that exceeded logical_decoding_work_mem were > written to disk until the transaction completed. I was going to post a question about the above bullet point(s), so this clarification helps -- thanks! Two comments on the above: 1. I do believe ther eis a missing "Tomas" in the first release note. 2. Would you want to s/standbys/subscribers/ given an instance can be in read/write mode but still receive logical changes? Or did this patch affect only subscribers that are also standbys? Thanks, Jonathan --6RSNlptif2zCT3JhsnPrsXohMvnXvSkGm-- --o8oikmdwaQk7QY26mLnnLo1r6Nq1Xc4V6 Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wsF5BAABCAAjFiEE+oS2la8r95ogZD/x8QSccp8cZScFAmCagvsFAwAAAAAACgkQ8QSccp8cZSeP 3Q//SCLy0xQpN9wlBGTzGxTVn9UZ3ErYQgHyIFmiFXa4UrDUj1AGDR5hS9ULT3zkJ3fP9nhI96Gq +ggwKwHy8nqqd1/0cLuVjEf0PrJPFJSNQvlOaeROOsms4m4995MEIg3zXhg7sYn91/DY1G56Ztai lYwDM4Fkt+QyNunlddyIoaYbnON9NylAWiWIFxBO4ER9U7xRhjF+rk9XeTuRTTNUd9SltpiQjMLV JUk0+uKS20kZ7OAMxMyzTZhM3BYrVe6YZqGSf4h+eI29gue5Xo5Z0axE1LN7X8zBgYmo2giK+tQr fGl7pMeGa1cEVeIdXaT9gjBk9MCfwEKC4z2uRa8mZmsglRYQkO6Y6b5haL05KWje2wdWTFKAd+LU 0f90LtmlplpYny+9KyOVnBt2nQV8nyp5f3yXIQU14OkOTToFYabSo6KMhy31H3+r9AHopP0oh+oc yxHyGQ0d69nfHoZ3kYSsiDZFg2h/rJwMbFbF0dbjeH/Gdw9YDlQJ3tdHgzOaqnxjkQNE/5mLpxEn pZgF0FL/JxKCXjDnkM7gkIYxcpFZWL0oXBFpB4GoJQk5yeZIaExRB74UYuDA9c+Xug8oMm1gkXBH XVIi447ZCx63u/PrZZlIFuCYOL/4eInTvYsvqu+Wudg50N5Cp6kmUkEqCR1KBsv/fnom2GPccQ46 mbY= =Lrw1 -----END PGP SIGNATURE----- --o8oikmdwaQk7QY26mLnnLo1r6Nq1Xc4V6--