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 1mkEP5-0007Vq-DX for pgsql-hackers@arkaria.postgresql.org; Mon, 08 Nov 2021 23:50:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mkEP4-0000TP-Bv for pgsql-hackers@arkaria.postgresql.org; Mon, 08 Nov 2021 23:50:18 +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 1mkEP4-0000SN-0H for pgsql-hackers@lists.postgresql.org; Mon, 08 Nov 2021 23:50:18 +0000 Received: from mail-yb1-xb2f.google.com ([2607:f8b0:4864:20::b2f]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mkEOx-0006u4-Di for pgsql-hackers@lists.postgresql.org; Mon, 08 Nov 2021 23:50:17 +0000 Received: by mail-yb1-xb2f.google.com with SMTP id a129so48103715yba.10 for ; Mon, 08 Nov 2021 15:50:10 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=7/8sj0e4mwr4kWrs2T0FgltO0zebozb4fR4vQRS7YDg=; b=qQ7vRj4DyhfnIVwBMiQL4F4N1fm3cJnGHdA5KW+2sZ0kg8fVjFC7Ysdy7YCGu+uDlI 5Ub3cloMZ3bw1kqZiLg1tC3G7BcV/koUEDL6wqS2lQO6Ys/PNXBCzHrU0jOWr2vuL3Kn P6upacghJd2EZbArf9YZ7j4a0zaceM28zucUrcr6av+ZmSFjdLcSTWHPWgQfgr3MjZ1/ ETpG/XOInNy+ONyrGlPDkuAxHSt84Gt7+WbPYGQ8OCpqCHdL0iII/lz5suZk9T2BiEVO lHkl3JFHeZxSz4rRbCvQ37wsCLn7SP/q/1rUdyn8DQNjj0F6F6olalJz90XUWySISVNH YNPw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=7/8sj0e4mwr4kWrs2T0FgltO0zebozb4fR4vQRS7YDg=; b=jEPSJAkj5FqV86zpHEnSPVW8oTXYIhSzxTV2SkoP5C8jkRPCmKkzi4Ne+nSPirXYFf 467KKXye5JKD1JH+etMcgwfZ/2Pq5LyAlOP2aCDjXpDZH1HH3VHGLQBp6b8cqH1i3Oqu eQMoaCjbJtpvRu92XlWVUec2eXSJvvVI2NQVLubmbnoK8B2Ii8tU/isv8ih5yX6TvKZR +0GlgQ4XOG/BOoO5vg6+lr/q7we07ZogeTYe+62/P6M4MGjM+e3vItcJ4l/6Rx6UwkcX 0HlcfjR5jUu1YH9dWCAbPGaLtZbJIR145YHD1dRKTSjI8qEHfT5xCuWZlr8AITP3bRZZ wLwg== X-Gm-Message-State: AOAM5310+hp5hVRyU/PJ8GtAYZ/k5oUAt+SSG8haNuX7py6xD5BenzyY c2Qq/il2dCaz6Byms4AM2Ri2721ggqXw1NJet+g= X-Google-Smtp-Source: ABdhPJzT5jehsKiUjrkTGzfrqqzOXMf5el4/IjIec+P7Y9H8Rj7fZzsn3Z5z2S9HRBDyVOxvRPY0Ch2mVFZ+yJIdNxo= X-Received: by 2002:a25:747:: with SMTP id 68mr3414730ybh.151.1636415409508; Mon, 08 Nov 2021 15:50:09 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Greg Nancarrow Date: Tue, 9 Nov 2021 10:50:03 +1100 Message-ID: Subject: Re: Failed transaction statistics to measure the logical replication progress To: "osumi.takamichi@fujitsu.com" Cc: Masahiko Sawada , Amit Kapila , "houzj.fnst@fujitsu.com" , "pgsql-hackers@lists.postgresql.org" Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Nov 5, 2021 at 7:11 PM osumi.takamichi@fujitsu.com wrote: > > I'm not sure about the last part. > > additionally increase the available subscriber memory, > Which GUC parameter did you mean by this ? > Could we point out and enalrge the memory size only for > subscriber's apply processing intentionally ? > I incorporated (7) except for this last part. > Will revise according to your reply. > I might have misinterpreted your original description, so I'll re-review that in your latest patch. As a newer version (v20) of the prerequisite patch was posted a day ago, it looks like your patch needs to be rebased against that (as it currently applies on top of the v19 version only). Regards, Greg Nancarrow Fujitsu Australia