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 1p58QP-0002rb-Pp for pgsql-hackers@arkaria.postgresql.org; Tue, 13 Dec 2022 16:46: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 1p58QO-0004Ft-Lf for pgsql-hackers@arkaria.postgresql.org; Tue, 13 Dec 2022 16:46: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 1p58QO-0004Fk-CZ for pgsql-hackers@lists.postgresql.org; Tue, 13 Dec 2022 16:46:36 +0000 Received: from mail-wm1-x336.google.com ([2a00:1450:4864:20::336]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1p58QM-0002ak-5r for pgsql-hackers@postgresql.org; Tue, 13 Dec 2022 16:46:35 +0000 Received: by mail-wm1-x336.google.com with SMTP id m19so8877369wms.5 for ; Tue, 13 Dec 2022 08:46:34 -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=2YeLqPxWsSaN+qijD4Xw9U/t9g+cv6pJV8zag++Cd1c=; b=kC+CABkHPYC5YVobjb0nz/N8SSbwpwWW3qjy17CV+rI4k3JUObPN/LzatYjuT+rAq2 3X2/G92BKlxwRCNqYJrjdlueyit9iDfst/EWOLsvu81F8Z3DysZrUby2uWhvqeptxj9A 0qmWk85T/g1FvYPX2q6ThbuR/M3Ejoi1A1Ar+RVSDfjZd00GhkiowUDG+WQuKcfBuATd hOO1yqM9AFgOKQF0ZcN9/EaXAtIYSsYRa/7rySX7POQu2hSnWK8aTEYpoU/Y0PJbwqwf xLRkRJKWc1oW7Oy4u0oPlOFuRy0tLSuLjvksYVz5zGdsMML0jD+itt8NNnezxI4PyEGb FBpQ== 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=2YeLqPxWsSaN+qijD4Xw9U/t9g+cv6pJV8zag++Cd1c=; b=F5yfUzcaz/Tr/Ce3y5aXlbQJL6Z2lOIAnKCvOvugX+QOLYYhaiMUD/JzPkQF7BqJAc AS5sFiO2JVzuiFwIdutgEROVJ/DVhm3aZfDtHl9V9++Ty9bTCNy3U6WEJAS9PufylKUP AuSPuw16Cn24mQ+HL2FMkvrsg2UAxDwBXWB1KkjmoWkdGv6LHoJrHiEzEyxeZOqraPpK pFj23sBx3QPYGrQhjvuRSTSBTB9jYmEfOb0c3q08hJkGCquMUMFac05qRh82hDSuFYig LZDCxHTRM7UyGTJpbzxEzIj+53Wc15KKPiJEDPZbmk/dVymgfL/9OoBiVL1mH7BsJHeo l8bQ== X-Gm-Message-State: ANoB5pm0fK7/XIbWfJr7ksBCGq2t9RA5qLJdTzJgtes5N0znffkKzpWb 9gOhp5kBYwTuVdIAWPGTmo4= X-Google-Smtp-Source: AA0mqf58V2UFzoee/fiSXqXMZwTgsgINPfiZvIH3DZkMx/tl3ZJjgGxixVH5CySvey8ggcYNU2MBPg== X-Received: by 2002:a7b:c406:0:b0:3cf:a0f6:1942 with SMTP id k6-20020a7bc406000000b003cfa0f61942mr17010702wmi.34.1670949992783; Tue, 13 Dec 2022 08:46:32 -0800 (PST) Received: from [10.95.75.76] ([54.239.6.178]) by smtp.gmail.com with ESMTPSA id g23-20020a05600c4c9700b003cf4ec90938sm12695949wmp.21.2022.12.13.08.46.31 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 13 Dec 2022 08:46:32 -0800 (PST) Message-ID: <783e2c8e-81a7-dbaf-8f8a-7054fd729ba6@gmail.com> Date: Tue, 13 Dec 2022 17:46:31 +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: <2b14d595-1e8b-e5b6-6098-6a11d19fa1c7@amazon.com> <688cbedf-a172-f0d8-8352-d4ea223bceeb@amazon.com> <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> 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:42 PM, Robert Haas wrote: > On Tue, Dec 13, 2022 at 11:37 AM Drouvot, Bertrand > wrote: >>> It seems kind of unfortunate to have to add payload to a whole bevy of >>> record types for this feature. I think it's worth it, both because the >>> feature is extremely important, >> >> 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 Regards, -- Bertrand Drouvot PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com