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 1phl6Y-0007ej-IM for pgsql-hackers@arkaria.postgresql.org; Thu, 30 Mar 2023 05:45:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1phl6W-0001VU-H0 for pgsql-hackers@arkaria.postgresql.org; Thu, 30 Mar 2023 05:45:44 +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 1phl6W-0001VL-7Z for pgsql-hackers@lists.postgresql.org; Thu, 30 Mar 2023 05:45:44 +0000 Received: from mail-pj1-x1035.google.com ([2607:f8b0:4864:20::1035]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1phl6U-0005Bg-2A for pgsql-hackers@postgresql.org; Thu, 30 Mar 2023 05:45:43 +0000 Received: by mail-pj1-x1035.google.com with SMTP id p3-20020a17090a74c300b0023f69bc7a68so18491942pjl.4 for ; Wed, 29 Mar 2023 22:45:41 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20210112.gappssmtp.com; s=20210112; t=1680155140; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=gPDyOhxhZm4cLQAIqU+N55nKHESbbcpqN21nS67MwpA=; b=bnynoYobTHGevgM7nCKRwQuY9AZKkZDFWI1QVHtndyCINP3gmW91DYmDBuq7D0WZhn JL+AA1JzrYbuJjbw1+xEuLAYKnyRPp1i66ofZeG07IbR+19tf3Vs91vty49awpAOkvcw VPkeeaVn0knGXmGU1B/jhkvAyOwJldva7gy+2qy/uviPhuZwvp5PnKUPxmNhLDnmlFu0 R8+UV0Vvk9f6AF2RwbgofN/AF1tzu4dkawn5XgbXobvRbE52zp/4cXF+zZBY9aiDZHOj xLlH9KTLLSHrwlmDS+kXPteZJyjhFW/Jfrlz+neAodb2Y99vdKc87HzV6cI2UdyLlxT2 tk4w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; t=1680155140; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=gPDyOhxhZm4cLQAIqU+N55nKHESbbcpqN21nS67MwpA=; b=BIB3UcH8r8qaxIgFXCdJ8Q4e+1N916V853uSAnqyv4lBfMVc0/j9p5BWR/HDokUBta rlveXNICHMzPQQ2BJtpWeCwz8EnlGJI/QdnF0l6mLFvdzmsKGk8R+Y6pYGYJoSmcmYzn iV1BOGX6fBmpihl4/oHUVXVFamv3EAFAdlLLbaHW3CAkeQFH5hly2B7Rlg8MYgHzgiTn FryKGB5Vs4xNlet0yblZPt8qaBYrtNvSOdySSXQEPYRYWVIAlNsShaG3poSwG1P/F4tF mKSiEC0DvguwdJoH7nCb9bVfkKivLGSYh1ttnz+TkS2QWEhuKBO2IzDv5puxVVBC4Pgd ZW0g== X-Gm-Message-State: AAQBX9dWTyARVayXkdVHHNjNiFwBRJZc8xip260cjdJEzVvFM/mObytJ zVq6FnKp3Uod2MilrL8g7u9+Sw== X-Google-Smtp-Source: AKy350Z5EuiAOJUbukE2EmFh5nVQEA13EfzbrRaONXJ9wRRMLllF6LDa2kjngMje1TxjJ/OOtwTG9Q== X-Received: by 2002:a05:6a20:914d:b0:db:c5c:e0a3 with SMTP id x13-20020a056a20914d00b000db0c5ce0a3mr4868054pzc.10.1680155139977; Wed, 29 Mar 2023 22:45:39 -0700 (PDT) Received: from jeff-laptop.lan (c-73-170-46-202.hsd1.ca.comcast.net. [73.170.46.202]) by smtp.gmail.com with ESMTPSA id w4-20020a654104000000b0049f5da82b12sm22250183pgp.93.2023.03.29.22.45.38 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 29 Mar 2023 22:45:39 -0700 (PDT) Message-ID: Subject: Re: Minimal logical decoding on standbys From: Jeff Davis To: "Drouvot, Bertrand" , Andres Freund Cc: Robert Haas , Thomas Munro , Alvaro Herrera , Ibrar Ahmed , Amit Khandekar , fabriziomello@gmail.com, tushar , Rahila Syed , pgsql-hackers Date: Wed, 29 Mar 2023 22:45:37 -0700 In-Reply-To: <6ab352de1553c1e3d0c7d97c038dc470ca51e772.camel@j-davis.com> 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> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.44.4-0ubuntu1 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 2023-03-02 at 23:58 -0800, 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. >=20 > I attached a sketch of one approach. 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. Another approach might be to extend WaitEventSets() to be able to wait on Condition Variables, rather than Condition Variables waiting on WaitEventSets. Thoughts? Regards, Jeff Davis