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 1p8Hkv-0001S9-R5 for pgsql-hackers@arkaria.postgresql.org; Thu, 22 Dec 2022 09:20:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p8Hkt-00012l-Om for pgsql-hackers@arkaria.postgresql.org; Thu, 22 Dec 2022 09:20:47 +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 1p8Hk1-00048F-Ln for pgsql-hackers@lists.postgresql.org; Thu, 22 Dec 2022 09:19:53 +0000 Received: from mail-yw1-x1135.google.com ([2607:f8b0:4864:20::1135]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1p8Hjz-0002H1-Tg for pgsql-hackers@lists.postgresql.org; Thu, 22 Dec 2022 09:19:53 +0000 Received: by mail-yw1-x1135.google.com with SMTP id 00721157ae682-460bb6ec44bso19976997b3.1 for ; Thu, 22 Dec 2022 01:19:51 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=Oyb3STxDTXQpLSy8TOVN8Q8uZuoB41uNom1t6XyKYEk=; b=Wa3+O7OE9wS9Vm6Mnmj4V7DMcBHgATs++Vq8JTB33yP0XJuIpDBijp3FFDYvAqzt1L WCrjT6Shj7ZA++VArVdqJz1u7tEcpUT8gEZkOnKB9qWO83PlYUeLccW+7N+sMwHJYbpN 83YnxzJudLvWB/VKUbwSyuM9hVLtgXHw3xzi6znG9HV1j5ka6T/XCP/3Mr42EqRzImih Fqs0o6miZmNt7+bZVovZMEnv9Ht7bg8YF1CzCZBv6TuE5FZ8ngx1SHtIVDJjDAJ5TAms JBX4vV0TBQquFbKHyF5PKi6+xA/fvH9OZzSE2hWfTttQ0o2WLHdXvOlMKXJ1FW5iNJwQ 8wRw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=Oyb3STxDTXQpLSy8TOVN8Q8uZuoB41uNom1t6XyKYEk=; b=1BLkxQGl875p/Y6trrfB+J4UFjzoz4x4qwYgZoUBRa/RFogZz6q9/sMlULQ58R9+HH xcpwS52NVBmKTKZx9w1Ae9foMcY8x9RNbq3xz4BrosunGcemEdaHQvZuBtQuvlEy98PC 1uLhIbZZ3ZKXbGoYTcKNTpfpUBomHaw7lMEMq67a2EedPTN1weYhXeo5pauSeQfWcCES x0kaedqlsggbjCIC6siGZ3cUImvt9xUxALbGovkZqI/PkUh5LxVW6xgqo4K27wtk3XJD Cslf/5zzn4Rxwu9G+NEgl8Q8Mxia8mIWHBZdjq7SpqhMBPmCt7Z++b23lgcGBscQipt0 UeXw== X-Gm-Message-State: AFqh2kr0ZFpMMpG6NVuEuFu/NfWquEkZWDCaFJAR39+kJx8TXaEtGvpR lSFCCx9vcqT1E6cESUitn8CJU7PWkLUCsFq9iQA= X-Google-Smtp-Source: AMrXdXsTg9RMw+akvYnON6HwLtf2c4P2pw1zeF//g+BvgEQhIY3v7Hti1V3+0S6Qi2WaNLfN2nNtLfA5IO4W15FeWus= X-Received: by 2002:a81:6005:0:b0:356:4adb:67b4 with SMTP id u5-20020a816005000000b003564adb67b4mr374721ywb.141.1671700790431; Thu, 22 Dec 2022 01:19:50 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Amit Kapila Date: Thu, 22 Dec 2022 14:49:40 +0530 Message-ID: Subject: Re: Force streaming every change in logical decoding To: Masahiko Sawada Cc: "shiy.fnst@fujitsu.com" , Peter Smith , "Hayato Kuroda (Fujitsu)" , Dilip Kumar , PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Dec 22, 2022 at 12:47 PM Masahiko Sawada wrote: > > On Thu, Dec 22, 2022 at 4:05 PM Amit Kapila wrote: > > > > > I think > > instead of adding new tests with this patch, it may be better to > > change some of the existing tests related to streaming to use this > > parameter as that will clearly show one of the purposes of this patch. > > +1. I think test_decoding/sql/stream.sql and spill.sql are good > candidates and we change logical replication TAP tests in a separate > patch. > I prefer the other way, let's first do TAP tests because that will also help immediately with the parallel apply feature. We need to execute most of those tests in parallel mode. -- With Regards, Amit Kapila.