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 1nWdKd-0005ot-16 for pgsql-hackers@arkaria.postgresql.org; Tue, 22 Mar 2022 12:09:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nWdKc-00041u-0A for pgsql-hackers@arkaria.postgresql.org; Tue, 22 Mar 2022 12:09:46 +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 1nWdKb-00041l-NO for pgsql-hackers@lists.postgresql.org; Tue, 22 Mar 2022 12:09:45 +0000 Received: from mail-yb1-xb36.google.com ([2607:f8b0:4864:20::b36]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nWdKZ-0002wz-Pw for pgsql-hackers@lists.postgresql.org; Tue, 22 Mar 2022 12:09:45 +0000 Received: by mail-yb1-xb36.google.com with SMTP id o5so33260166ybe.2 for ; Tue, 22 Mar 2022 05:09:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=ZFEWEyogIBgu2+QMs8kzy6VOllNSUPP24puLtU9A0+Y=; b=WGLIp3/DUVTvpJhTOwXFT5XM6uIa0gZKzFUbO3uqpQx1ZexsSaMfQmT6UhOoe/6RpV TsONK5+ICG6N/sAZVWxOXhnH4B3qRO1aZPMSO1qHBhZ/lIn24RkJCi+HrygzGPHYk2Q1 mG+k05zTCQVzovLqHvX54Qxeg3MJ7R6XM8x0ZOCVa9b1YxFlZ4s/OAgZepvdomqjmpCl e6Q5iNcEJWIaSnLQp7k+HXGn34k9Tlrsq9ZkQ6EiXQOGu8Xm2Xb5tlt7XKxS/IiNFjt+ 76aXRzfJa5FJyoNlhiaYe+poHu+9FsBPr70eF+fIM4WPbQy+oyM2K52u+980kNDjdLNN GXmw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=ZFEWEyogIBgu2+QMs8kzy6VOllNSUPP24puLtU9A0+Y=; b=sqN8vSpt2CKY6N3BlzUdFtoEFg0LT9wmlv4zN4vDkDgVgPWfca93e94OEGEzFaZXvX HBLi+W/hEOWdd8vPnDF5opJi/gnFh+aA6R7OX5jevQ0Xkwyh+WsYq3qII+1aWIbge1CW etcEiRzh5Um9gd68fEH3cVO2bIk+nHvhLWmg1kYBYogLeDUihC8oyk8w/T8CvRRuFSJ/ 6Pn4IOwJucTe49I6Ee9P5WlvLZ7tvw/iXerUT3xk0fhN9T479aYPlGloZCxG2GYlZzkn tt/dC8z5Hae9NQtxOWTFmLcdR0v/UH/5e5u4bw+kAYTDxgIKtskahEVKxn1rPTzh5SqF iDQQ== X-Gm-Message-State: AOAM5315JOT3bp4cHCGaFrNjtlImrtC4yo0NTsKFe38p30aeFbOAdDkE 1p6yMSJmKd57qHNhMrd3jnQyYEQdO2Zdw3H99aQ= X-Google-Smtp-Source: ABdhPJzn1ZjdL0A2NXKrghxCBHD91hJvKVPijDwaCaEIbHFas+iex8WiqZxkl/A+YOTHXR27bPxMwFQpKhEizib0W4M= X-Received: by 2002:a25:da8c:0:b0:633:86f1:c863 with SMTP id n134-20020a25da8c000000b0063386f1c863mr26549075ybf.495.1647950982075; Tue, 22 Mar 2022 05:09:42 -0700 (PDT) MIME-Version: 1.0 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> In-Reply-To: <9da788c7-01eb-f11d-aa08-c5f61fe9f33a@enterprisedb.com> From: Amit Kapila Date: Tue, 22 Mar 2022 17:39:31 +0530 Message-ID: Subject: Re: logical decoding and replication of sequences To: Tomas Vondra Cc: Peter Eisentraut , PostgreSQL Hackers , Petr Jelinek Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Mar 21, 2022 at 4:25 AM Tomas Vondra wrote: > > Hi, > > Attached is a rebased patch, addressing most of the remaining issues. > 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? -- With Regards, Amit Kapila.