Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w9xBj-001vCd-1g for pgsql-hackers@arkaria.postgresql.org; Tue, 07 Apr 2026 03:33:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w9xBg-00Dsh4-2r for pgsql-hackers@arkaria.postgresql.org; Tue, 07 Apr 2026 03:33:13 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w9xBg-00Dsgu-1y for pgsql-hackers@lists.postgresql.org; Tue, 07 Apr 2026 03:33:13 +0000 Received: from mail-lj1-x22f.google.com ([2a00:1450:4864:20::22f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w9xBf-00000000xlA-0uEM for pgsql-hackers@lists.postgresql.org; Tue, 07 Apr 2026 03:33:12 +0000 Received: by mail-lj1-x22f.google.com with SMTP id 38308e7fff4ca-38cc0b91b01so36597641fa.1 for ; Mon, 06 Apr 2026 20:33:11 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1775532788; cv=none; d=google.com; s=arc-20240605; b=Qi9tQUbL8pdAyklPCOE82KQtoTViYHEuu2do/9/A9mgrr/Ttg4/reUNtgWNEm7izrG yD5XdgcMUeuhKHrzhIFq2fc+N5LGSdYNePzweoCaIT17lcCKQ0XkdwaAJ54xylOdcAI7 TLxQ1pHOxFtHCj+i0Z73CkJGH718OzAu5oAF+bTbbbfR4WQUysarC3lon8OJTpxFHwF/ G8ZlAY/1SKtJvamEef+lWPZyDgh2TF2TJ41iU45lL+n+ZjKF1Q1uKxD6seNjBSm8UjpE qYEXAILhbJEhijG0hhe0lHC/WXrXZJOWj7L271PU3lgCXXYPAG4Y6ooaiGqrQcsOErp1 iO6Q== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=28SGr1+hvyi0Ys1lGOci94l8lTfvrzGJFQzlUc/0f8c=; fh=+tuG9R0JhHPJ2PNoolg7CIYmkzq6chPLzwSG1gMsidw=; b=doaajjk9121w0fo7vMySccvM53F+JgWFhBbcgbKhsdyTjHImPZgOg1cDTIv0M2JAFh JS0C7Uxhvif60uF/QnVC6RRgEbp5IFZwq/XkG8V13RCaAKtedrW4nnaAMCMTE6JRC0XI 1gEz5i57Y/J8lIurAICPuniexB8j3F+OTKvZXI2+WbZkGuM0Sxb1+wVPGuOGUt3aZE0S CaUETXh02IFlArpT9dL8Rhy8N/xaTAulBChhe5UMYdrESvlOaV4bb0qbGwoD3viLQ7hE Rs9J4QQwT36ZabcCpIye5qdJ5qUcbou2yBIqBSjJnqSMnlW1vWyLTHsnZlDNd6yPE6y3 6HoQ==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1775532788; x=1776137588; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=28SGr1+hvyi0Ys1lGOci94l8lTfvrzGJFQzlUc/0f8c=; b=qfHSjgeu3mwdO9T4r/1Lv6KhuDu8lg7h+2F8fPKbPOwNT+2xPAbZR9kexzbL1X/Ogf t5bvuo0t8c4itcGpwQsKhSODUciwkRz7kLAbOcZ2oL4vuiC7wYSA2C4uGuihxVBZxEkd YKc3TisrDfDGJJFxvrl6Z2TyY065xrNfPKOaDZWpoQhBygT7TM6Rhs0BLfYhEtDKo5rj Cq5VjFANsHzLyf34wrowkNlZaEqEoTYsfvFgQ+9XVI+NwHflVhwRESvKaI1WVkkiH1Vm w4DmPx3y5zuV6XxZXud3HNp7K3Y4+J/zIAe+PWcdr7FLnOe0E7P/UmLgbiqWm3uxUWBT CHuQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775532788; x=1776137588; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=28SGr1+hvyi0Ys1lGOci94l8lTfvrzGJFQzlUc/0f8c=; b=gad8Vk7QbCPwjfcozQoAciboq9OerFMrzywNlu9ukJkpVCbFCjyp4fcHnoanH7wl+X 7mEQJKtrhyX+jMRSnf9KgrjgPT/Xtmx051Rsa7jKHG708J2EFmeIms0+Xcs0sGKsJV3U 4QEHN224ldyPSUuN6R5/QcPmKd1DK5zy8M+h09cN0sxymhclr/glyqbACCgmqPxjr/Rc oIxl/p+fsqsRKR0fQ+PSwb4Ab666jwxiR7VDQOrFMpjJqL1rJShy5YTxmvPxOZqv9wsl ZMSN7FRYTY8s/e/Exta1HgTlqro26i3vrawKXfnWbc2opt9vnOpaZ+0OF9vi9C2BQ3OL v86g== X-Forwarded-Encrypted: i=1; AJvYcCXR0bKP8p4MHkMWsr6qPP2avitvDyqhQy0R/DsKBXkTJLjh3c1/iStjvXpqoTbuiiUDMy5pLCwf8qGAdcBn@lists.postgresql.org X-Gm-Message-State: AOJu0YzKrxF7mI88TALsCYcjxMHAWCvIvkJdemgBJKf6uYb75+4V/3dm UANL3gLcM2NRJ3QYqfSPdQTbjiVNx1ODITLItSb/yWT+qyidJTEU5bQ2UdWGSRE8oSOt9kaZRZp 2QsE+r0j3JKx2ABibotdQ8OdluKhYTnU= X-Gm-Gg: AeBDiesp9gUAE/vsYteB20V6oplW2ycKI44dzFrcJ4IpbmQer6Rvstm+ctQV1s24V0k QIors/ozUsliGo9s5GP93w13taEA1NIuL7tGiHcZpayOqrtWFZKGS9DzW05ih1/Kq3jV/MiTXKr hnFslrMsE+42dKoRPPff06L9O1aXR7SCYl0cV+JnFXxCCpA7AziMkPIeLzeOM5UxuSwnSUYSnuG uTpcqwed5pqgZHBcnBbGk11jUjqvlfD6xUsJp789jevMgAxpQGW7K/5HXfgv4qOuThuFxq6lUWK CcB335w1XWhQ0pVN6ZmUXXuROv00UTq1Rb0+4WM= X-Received: by 2002:a05:651c:24b:b0:38d:d98e:e41e with SMTP id 38308e7fff4ca-38dd98eefd0mr42109001fa.32.1775532787891; Mon, 06 Apr 2026 20:33:07 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Amit Kapila Date: Tue, 7 Apr 2026 09:02:54 +0530 X-Gm-Features: AQROBzDPc7UO6L__tpL3wvgnSCZ3gNBBF8YzMg-kPTOfBKPNWTMFrxyWoOOy2_4 Message-ID: Subject: Re: pgsql: Reduce log level of some logical decoding messages from LOG to D To: Fujii Masao Cc: Robert Haas , PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, Apr 7, 2026 at 8:48=E2=80=AFAM Amit Kapila wrote: > > On Tue, Apr 7, 2026 at 8:34=E2=80=AFAM Fujii Masao wrote: > > > > On Tue, Apr 7, 2026 at 1:16=E2=80=AFAM Robert Haas wrote: > > > > But probably are you suggesting making this behavior the default? I= f yes, > > > > one straightforward approach to implement that would be to log thes= e messages > > > > at LOG when AmWalSenderProcess() or AmLogicalSlotSyncWorkerProcess(= ) is true, > > > > and at DEBUG1 otherwise. > > > > > > Yeah. > > > > OK, I've prepared a patch to implement this. Patch attached. > > It introduces a LogicalDecodingLogLevel() macro to choose the log level > > based on context, but the name may not be ideal, so suggestions are wel= come. > > > > How about adding repack_worker to that check as well? See 28d534e2ae. > The other possibility is to use AmRegularBackendProcess() to decide the log_level in this case. --=20 With Regards, Amit Kapila.