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 1pY8Ex-0003st-ER for pgsql-hackers@arkaria.postgresql.org; Fri, 03 Mar 2023 16:26:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pY8Ev-0004mE-SK for pgsql-hackers@arkaria.postgresql.org; Fri, 03 Mar 2023 16:26:37 +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 1pY8Ev-0004m4-Gi for pgsql-hackers@lists.postgresql.org; Fri, 03 Mar 2023 16:26:37 +0000 Received: from mail-wm1-x32d.google.com ([2a00:1450:4864:20::32d]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pY8Es-0007GC-Sn for pgsql-hackers@postgresql.org; Fri, 03 Mar 2023 16:26:36 +0000 Received: by mail-wm1-x32d.google.com with SMTP id az36so1970402wmb.1 for ; Fri, 03 Mar 2023 08:26:34 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; t=1677860793; 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=k9bjJX9W4ZansOGXXfXiGeoi6SwK5nFZ+0cZPASoMS8=; b=PYLjdrlU+NI7oyV9x4Be1MwUsDjDTt+uLng9uK91zf0vjoG+S9CY2Cp5x/7lm0/nNe ztvVk7agQ7NLw+A6zIY2okHJg9I4bZ5XNzLIBO9B8MP5vC/DvdRABzVG0ZI4TZkQ6YdX 99EaI+bqkUGbDHp8Ayo0rfI7JiVso6MDSw/L7LQN6s/Afi7QaQzdzOSLqM4htxHurqJR DQSIuP0ZswqeaT0KRXDmdaN1p1ojAXgwxc2pOHjnA29gc8w6VvFn3/OwwvUcDZKjwdbp WehoQoASspQSQ0CJrEozw0MC73lUMc9EpfAjvjvdbIGq4p0qEEFG/2U+1ydr5kRGXxxi 1FKw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; t=1677860793; 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=k9bjJX9W4ZansOGXXfXiGeoi6SwK5nFZ+0cZPASoMS8=; b=eYJXbj81oz8quv0YX/juuk7PTBUvKGotty8li0nOnticEGB2gSeoFk5fO1YF0XxYeb Pw9JdWWACbaoT2SCYnCjkAVaw0WKUaPfmGRzHsmewgLrNCcdxT66qmYBO7QyeAzkAeoI /X/L7dYmanOa9HyIS0hAlZWRiN9/uDIL2UhRyyFw9kVxzDvSkki+6ZVTDguRWMb6XcwF vll/bJxqWGgOlwIUlv5EEtuTsjZ1DekXEgSZ5soYLZ0/r24zZ5vZXFnvtQ2Gss0WwSjJ GQmEtOBi+qkb6Pi5inv97xgCkyMc5hkF2+dbD+jeZtN49kBg7kQRGQYzyrmjMb9zC5D6 bvrQ== X-Gm-Message-State: AO0yUKW+I1IEGmNPvG2lueKnZG5/j7npEwht0a3obwDNOpTmbH1Aa7qS K3a1zGa14RmgX1/1txw8dSs= X-Google-Smtp-Source: AK7set+uvWGY+D/g38SmknNRYWIvqZZi72fEbSxrdTECSw5xNLAnmLXBqwLwPx0sfXYgC8g9qlzq1g== X-Received: by 2002:a05:600c:3553:b0:3e2:1e31:36bc with SMTP id i19-20020a05600c355300b003e21e3136bcmr2094059wmq.12.1677860793386; Fri, 03 Mar 2023 08:26:33 -0800 (PST) Received: from [192.168.2.139] ([54.239.6.189]) by smtp.gmail.com with ESMTPSA id l36-20020a05600c08a400b003eb39e60ec9sm2687080wmp.36.2023.03.03.08.26.32 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 03 Mar 2023 08:26:32 -0800 (PST) Message-ID: <4df984c8-3adb-3b69-0e4e-a491097862ce@gmail.com> Date: Fri, 3 Mar 2023 17:26: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.8.0 Subject: Re: Minimal logical decoding on standbys Content-Language: en-US To: Jeff Davis , Andres Freund Cc: Robert Haas , Thomas Munro , Alvaro Herrera , Ibrar Ahmed , Amit Khandekar , fabriziomello@gmail.com, tushar , Rahila Syed , pgsql-hackers References: <1f2ad9fd-53ff-74cc-a602-72d45423bcab@gmail.com> <05c0c4f3-82eb-bc6d-c876-5a265c05927b@gmail.com> <20230106034036.2m4qnn7ep7b5ipet@awork3.anarazel.de> <490206c5-bcde-e558-628a-dc67dae4d439@gmail.com> <20230119024617.jzsgpcrgjdc6ysge@awork3.anarazel.de> <94d9d47e-72f4-393a-246e-e3fe8db7b741@gmail.com> <2d314c22b9e03415aa1c7d8fd1f698dae60effa7.camel@j-davis.com> <061eeb26-156e-6011-02b6-b4b1422e2aa6@gmail.com> <8a7da0c2-b7fe-1c78-4e47-a16239bf4839@gmail.com> <6ab352de1553c1e3d0c7d97c038dc470ca51e772.camel@j-davis.com> From: "Drouvot, Bertrand" In-Reply-To: <6ab352de1553c1e3d0c7d97c038dc470ca51e772.camel@j-davis.com> 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 Hi, On 3/3/23 8:58 AM, Jeff Davis wrote: > On Thu, 2023-03-02 at 11:45 -0800, Jeff Davis wrote: >> In this case it looks easier to add the right API than to be sure >> about >> whether it's needed or not. > > I attached a sketch of one approach. Oh, that's very cool, thanks a lot! > I'm not very confident that it's > the right API or even that it works as I intended it, but if others > like the approach I can work on it some more. > I'll look at it early next week. Regards, -- Bertrand Drouvot PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com