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 1nWdMP-0005sy-Oe for pgsql-hackers@arkaria.postgresql.org; Tue, 22 Mar 2022 12:11:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nWdMO-00079g-Lm for pgsql-hackers@arkaria.postgresql.org; Tue, 22 Mar 2022 12:11:36 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nWdMO-00079X-0o for pgsql-hackers@lists.postgresql.org; Tue, 22 Mar 2022 12:11:36 +0000 Received: from mail-ed1-x533.google.com ([2a00:1450:4864:20::533]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nWdML-000681-74 for pgsql-hackers@lists.postgresql.org; Tue, 22 Mar 2022 12:11:34 +0000 Received: by mail-ed1-x533.google.com with SMTP id h1so21395257edj.1 for ; Tue, 22 Mar 2022 05:11:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; h=mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=Iq/rk9PZKFvlPqN2X0JqLldlA3NQvIt+BFCmweHKbkI=; b=KQ55eRDmhVzy6cLE2yDhQfpwVelcoHcndsmCaDt5PVMqbuaHKC68GHZ/KK6w1efTrr hJ2vj59PJX56S7V+qXazhPxNL1+pogaaIqiKJEGqOuF6IeyU31jhTVqfVzisAeZ5bq8j 8iuGZ80TTzxHS+usor7Nlxyi642Y8A+AH7CUCc1ntS7jfCu34XV+8Xh4SpZKigHQuLel YjgNVrzV6eL5ZT9HbXMs532EoMAKboZzX6C4cbLBsVK0U2yFhnylkwISvg2Vn3567Z8N KqNEbibB1UdXHLo+uMrDkKi9emh9Vm7zh1b7nWapEXrkk78FV38PEN+KTNru1YnLWCgP oPYA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=Iq/rk9PZKFvlPqN2X0JqLldlA3NQvIt+BFCmweHKbkI=; b=m80cVaoIyW8gPdZRhBQG5t5TwCiv5HiqsOMaH3CEKt9NOVOwodBlx6zonb5rZ6tgXq emZ6t7HPwt18YLclRyyRqPrXtU17jl8VVFkgMASaa5zUNm3/k4mcSO9gY5W2ZXiUi1LN KTL27rfJpgBWnuAhfhd7FvYFa+gli3Y5lV3E4M2f7mvqjte/L3ABrT2Be7s34MjdJUkr W/h4X+2y3ib7PodWU1zIESpRtthulIgfexdlhAiSpf0BBQhmqfDQFAGI1aEMAyhrN6br gdbZMD8UA766Ct4+RkHcPs05o9lGg4GhylzR5FOi18CLxKZKDkhkIXuaQngDqxQTRwVe t/Dg== X-Gm-Message-State: AOAM5313dQj4659BZhwq8oKJpb7wbKDbeHXbi/LY/Y/mOI3mlz8WPESr x8kn28ETCIlRUmclAPrhfhia/D4KHB2xhIk0dJrnMMqwklUZlnZZImVFQbshJ8mOXE88ncXypdh aUFpLpN/LNrRw2tuxstwXQ5ZsXM44QkZ7ELJXXVkwhu2T95YZ19LwLUZs3RwrTwchd+ryYuHQZC XZ84EA6cb1gvRSGjN8uxCOxN7G2HJnkJ5/YAedvact7Fnx27b0RjoJ X-Google-Smtp-Source: ABdhPJw4E9FrF8BLEpsTvYeYMIoDKXD7+SyeyPqwpfVd5WAXGqDpyoTPYs7DhgXp07muRSTI/yowlQ== X-Received: by 2002:a05:6402:2342:b0:419:e86:c7d5 with SMTP id r2-20020a056402234200b004190e86c7d5mr21344965eda.92.1647951091004; Tue, 22 Mar 2022 05:11:31 -0700 (PDT) Received: from smtpclient.apple (cst2-164-81.cust.vodafone.cz. [31.30.164.81]) by smtp.gmail.com with ESMTPSA id go40-20020a1709070da800b006dfc3945312sm5125929ejc.202.2022.03.22.05.11.30 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Tue, 22 Mar 2022 05:11:30 -0700 (PDT) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 15.0 \(3693.40.0.1.81\)) Subject: Re: logical decoding and replication of sequences From: Petr Jelinek In-Reply-To: Date: Tue, 22 Mar 2022 13:11:29 +0100 Cc: Tomas Vondra , Peter Eisentraut , PostgreSQL Hackers Content-Transfer-Encoding: quoted-printable Message-Id: <456A528F-8F19-41C7-9857-927024D32396@enterprisedb.com> References: <32540e16-fab6-f790-b99b-5a8fca8bde52@enterprisedb.com> <3B014BE4-EE61-4834-8FF6-937B43C46BC7@enterprisedb.com> <3d68b45a-ceb5-6824-3a39-f53411fd0c88@enterprisedb.com> <802f8b1b-a798-be52-c829-7f0fb9faafd5@enterprisedb.com> <983bf0c7-9757-fd13-3896-8452cf4c4c52@enterprisedb.com> <9211312a-6501-1caf-ee7b-c0d4814b6091@enterprisedb.com> <41ada110-bc7c-32a3-08bd-fb5023dd74ba@enterprisedb.com> <2eed0f76-3a1a-8b8b-ac1b-e0f9a0d98287@enterprisedb.com> <9defb937-20a9-1d9f-6972-f1c4b4da4f73@enterprisedb.com> <8e766e0f-ed3e-fd68-4b0f-10dd2db60c88@enterprisedb.com> <6b21233e-c880-e4ad-5df2-7832f769296c@enterprisedb.com> <9da788c7-01eb-f11d-aa08-c5f61fe9f33a@enterprisedb.com> To: Amit Kapila X-Mailer: Apple Mail (2.3693.40.0.1.81) X-CLOUD-SEC-AV-Info: enterprisedb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On 22. 3. 2022, at 13:09, Amit Kapila wrote: >=20 > On Mon, Mar 21, 2022 at 4:25 AM Tomas Vondra > wrote: >>=20 >> Hi, >>=20 >> Attached is a rebased patch, addressing most of the remaining issues. >>=20 >=20 > It appears that on the apply side, the patch always creates a new > relfilenode irrespective of whether the sequence message is > transactional or not. Is it required to create a new relfilenode for > non-transactional messages? If not that could be costly? >=20 That's a good catch, I think we should just write the page in the = non-transactional case, no need to mess with relnodes. Petr=