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 1pA8H5-0000Ks-Qm for pgsql-hackers@arkaria.postgresql.org; Tue, 27 Dec 2022 11:37: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 1pA8H4-00088y-Ne for pgsql-hackers@arkaria.postgresql.org; Tue, 27 Dec 2022 11:37:38 +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 1pA8H4-00088b-CD for pgsql-hackers@lists.postgresql.org; Tue, 27 Dec 2022 11:37:38 +0000 Received: from mail-ua1-x933.google.com ([2607:f8b0:4864:20::933]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pA8H0-0005oQ-QA for pgsql-hackers@lists.postgresql.org; Tue, 27 Dec 2022 11:37:37 +0000 Received: by mail-ua1-x933.google.com with SMTP id z23so2883157uae.7 for ; Tue, 27 Dec 2022 03:37:34 -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=dcfFfx/lF3CBZCvFK91fNIXKquuvEkUFCnONQmz6f+o=; b=BdbBDGZ/wnBTXaKhafPB1mqCJUy7GUCiWzQg/g4rZ03//56PiapEHM7JMH0rvvnElk BzOrwrQKmnPpM5nZ9fVa/gUi9mg+mPGMM2TB8nQDYbGMXJN7OmItJDtjCHiKDx4zdLg0 1Cl9a3LWDb74gOHNiNbkAuGTKk99FbuM+7HGbHt4OmSUsRokYIYcSSlCTPfC6biZ4DbJ 2ZUCBCcfb52wn/Aikzz7vSd/QsVooYz5RgjieGy6hH62GhibTaDIxet0QVmxND/7V/R5 t8ScvSM/vdKccOOZ0QK8qfu/anUxVzTshYfR1dc8YPyxkbj2YtkTbsrSFJh/vFkWurvr u+7g== 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=dcfFfx/lF3CBZCvFK91fNIXKquuvEkUFCnONQmz6f+o=; b=auf9JyZY8BLgQMb9NyPESvsn51m6RBjVLjKoch5o54a4m0fnYJnEjb2UFBwgsCPYuS 1nieqxKSVg22QFS/LofNsQvGvuzZtYaAcQ1qeqNhKJiYjyq/e/KWoaPPkwtPSgqFaKsy tKlL/7PZt0YoLb7HUxJ8LpiQapbOv423UrbfwYgzpkXHH/+9gbMid9K9Q5fGmCrsL5aI 0ZY+27SJsrHfh5dohAx/nGhsTcmySjphJzXm1l0qmyNbAqnvBJBJY49uM+TNLsd3s8/d WeorU/mZAY/u0kFjGNG+1hwBEgr7UWat/8OSQ+wuaCNbB+oc6tz1ASRY6Ga7RLWfHt6W t5Rg== X-Gm-Message-State: AFqh2krmvgHoi66LGJmPZZNZ3b8Kz0lIRiNRlO98oTlpr50UeO+kIzuc JJLWvxHzhqxpKd3r8jT9KbFWvvJyp4z//nRjlTg= X-Google-Smtp-Source: AMrXdXshKWt5E4WIi/NdoyY1kq2q7qjgvekg7MFYCEZm2q6TyYPXtCJRlCvzXeLTWAcKiotw6kgZ1OC+/Zx+Cdk35/g= X-Received: by 2002:ab0:6095:0:b0:466:c8af:b52f with SMTP id i21-20020ab06095000000b00466c8afb52fmr2104154ual.42.1672141052712; Tue, 27 Dec 2022 03:37:32 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Amit Kapila Date: Tue, 27 Dec 2022 17:07:20 +0530 Message-ID: Subject: Re: Perform streaming logical transactions by background workers and parallel apply To: "wangw.fnst@fujitsu.com" Cc: "houzj.fnst@fujitsu.com" , Peter Smith , Masahiko Sawada , Dilip Kumar , "shiy.fnst@fujitsu.com" , 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 Tue, Dec 27, 2022 at 10:24 AM wangw.fnst@fujitsu.com wrote: > > Attach the new version patch which addressed all above comments and part of > comments from [1] except one comment that are being discussed. > 1. +# Test that the deadlock is detected among leader and parallel apply workers. + +$node_subscriber->append_conf('postgresql.conf', "deadlock_timeout = 1ms"); +$node_subscriber->reload; + A. I see that the other existing tests have deadlock_timeout set as 10ms, 100ms, 100s, etc. Is there a reason to keep so low here? Shall we keep it as 10ms? B. /among leader/among the leader 2. Can we leave having tests in 022_twophase_cascade to be covered by parallel mode? The two-phase and parallel apply will be covered by 023_twophase_stream, so not sure if we get any extra coverage by 022_twophase_cascade. 3. Let's combine 0001 and 0002 as both have got reviewed independently. -- With Regards, Amit Kapila.