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 1p58U2-00033V-SH for pgsql-hackers@arkaria.postgresql.org; Tue, 13 Dec 2022 16:50:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p58U1-0001FQ-HN for pgsql-hackers@arkaria.postgresql.org; Tue, 13 Dec 2022 16:50:21 +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 1p58U1-0001FH-8l for pgsql-hackers@lists.postgresql.org; Tue, 13 Dec 2022 16:50:21 +0000 Received: from mail-wm1-x331.google.com ([2a00:1450:4864:20::331]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1p58Tv-000643-LV for pgsql-hackers@postgresql.org; Tue, 13 Dec 2022 16:50:20 +0000 Received: by mail-wm1-x331.google.com with SMTP id bg10so8910620wmb.1 for ; Tue, 13 Dec 2022 08:50:15 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=qKxJm0V5fm1sCs+V/8UCb2sN0WA2t/8Q3OxuRkkCrnA=; b=YJAHFkmjC4Js1FzqMikPLlhvOVDnM53zNQmP3wA13Tb334wlX0mMh9GKfl0QcRPUCp fFIP1+ihGrcb0wFEvRFQb8LW8DTa/wh8F1f+oarBTxHGaESeDobptjGDcw5Xgd+Zv+Kw XHUl9XuSaUxkFRtPe7Dog1DXrTJpk8AfKr8z0EmL8ZjphF+BsqFBra1sA/GSKaOmiNGV FAL0keexZ0dPKw1yIobK8sQHM+rSprw5E6FjGQfoYIztxK82z2qmAAfpfiZ2Gee1eafF yOIZwkWUEEUgKwo4QMM5JKwrN/RTq7cKtYZMlLVQ0TMWpmhTQxQeTPAbZFnCW5jx9XfH D0lg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=qKxJm0V5fm1sCs+V/8UCb2sN0WA2t/8Q3OxuRkkCrnA=; b=WhRmWfJCnP3bStMq92Yj3SMNaZ/pzmwAnOZnVLe9+505e4e7GIxsgT1KgPzzz3wkYf aYO1KeRwK1OKcF0tmBmoUBI1RHfo5Vk78HaMER9BfscnQDphpzt4zbIlXsKvvIcFaq7S u/GgzggabKhMfuCzRCSsxu695DgEuiSUP1NJrSGIsUL+tU5Yx4QPrw1pBq3ucbq13JIO E5FNPWCqwUesVSAZ+P+D3bhCzERWDDnoJYNAMSasmO2ZurHe5LmjX6zdmzZZCp+OHA4O dXFo+EOJ2pUQh1h5mDaMV89HxtoD+7p/zQYa+8ory1fchOrbfvQ3YfOURBDdrqWN7o7g 1PVw== X-Gm-Message-State: ANoB5ply3LhdrzvBp0He7pa3y/l8pb+X29UYXUwNPpQFg3UyEvPUCKFP y8/aMZ4mK7GY1W5TYrJ3qDI= X-Google-Smtp-Source: AA0mqf4Cq+FnnvkdyPMXjOe0Gycof6Qfhxs+w/w3fwZun8/OnrHgdALpH51BrWwlxlcN60Ka7YfpuQ== X-Received: by 2002:a1c:ed04:0:b0:3cf:7514:a82e with SMTP id l4-20020a1ced04000000b003cf7514a82emr16176493wmh.23.1670950214253; Tue, 13 Dec 2022 08:50:14 -0800 (PST) Received: from [10.95.75.76] ([54.239.6.178]) by smtp.gmail.com with ESMTPSA id l8-20020a05600c4f0800b003cf54b77bfesm14208000wmq.28.2022.12.13.08.50.13 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 13 Dec 2022 08:50:13 -0800 (PST) Message-ID: <26823feb-049d-1b22-84e6-2e714499989e@gmail.com> Date: Tue, 13 Dec 2022 17:50:12 +0100 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0) Gecko/20100101 Thunderbird/102.5.1 Subject: Re: Minimal logical decoding on standbys Content-Language: en-US To: Robert Haas Cc: Andres Freund , Alvaro Herrera , Ibrar Ahmed , Amit Khandekar , fabriziomello@gmail.com, tushar , Rahila Syed , pgsql-hackers References: <20211028210755.afmwcvpo6ajwdx6n@alap3.anarazel.de> <6711d09f-eaa9-264b-ec7f-88004218b075@amazon.com> <178cf7da-9bd7-e328-9c49-e28ac4701352@gmail.com> <4b19419f-2e7c-a76b-c948-26d10af6693d@gmail.com> <20221207175824.apmc5clnj2fdjkaq@awork3.anarazel.de> <09c26df0-c5f9-eae0-5a6a-10fb00b0522e@gmail.com> <9f0a021e-40e1-0ae6-8086-a4457c99749e@gmail.com> <0ae83e69-bda0-0eb8-ef4a-d169292e3f66@gmail.com> <783e2c8e-81a7-dbaf-8f8a-7054fd729ba6@gmail.com> From: "Drouvot, Bertrand" In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 12/13/22 5:49 PM, Robert Haas wrote: > On Tue, Dec 13, 2022 at 11:46 AM Drouvot, Bertrand > wrote: >>>> Agree and I don't think that there is other option than adding some payload in some WAL records (at the very beginning the proposal was to periodically log a new record >>>> that announces the current catalog xmin horizon). >>> >>> Hmm, why did we abandon that approach? It sounds like it has some promise. >> >> I should have put the reference to the discussion up-thread, it's in [1]. >> >> [1]: https://www.postgresql.org/message-id/flat/20181212204154.nsxf3gzqv3gesl32@alap3.anarazel.de > > Gotcha, thanks. > You're welcome! Regards, -- Bertrand Drouvot PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com