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 1wAK5P-002Gr6-3C for pgsql-hackers@arkaria.postgresql.org; Wed, 08 Apr 2026 04:00: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 1wAK5O-004aU8-0o for pgsql-hackers@arkaria.postgresql.org; Wed, 08 Apr 2026 04:00:14 +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 1wAK5N-004aTw-37 for pgsql-hackers@lists.postgresql.org; Wed, 08 Apr 2026 04:00:14 +0000 Received: from mail-pl1-x631.google.com ([2607:f8b0:4864:20::631]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wAK5M-000000019iG-2ema for pgsql-hackers@lists.postgresql.org; Wed, 08 Apr 2026 04:00:13 +0000 Received: by mail-pl1-x631.google.com with SMTP id d9443c01a7336-2b2503753efso47075845ad.0 for ; Tue, 07 Apr 2026 21:00:12 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1775620812; cv=none; d=google.com; s=arc-20240605; b=a+i/W9vSZMkUN6NCJxN20wkfwmDPegwL8anHV/QDNlG7ZLAxoez/89RjfyOOCE6om1 Q+ubIEXAuZxDhFLBYcOUr5lTrQNMXNm/SB3RbtbeN2sw5S+zTfTIlO0rNq9SlcUH7e/1 QEHQfihiUT8IkUfkFVR9GEc2QrdjBwMqgVZ5AxksTKdQ9qOqgEeKak3MZfAxEBUMQcPz tCKp/JpD10qx3QoiRSZVFLEswoQV5p4RTTnIn46ev2zUGiXXU4il5s3rGKRtsmjday91 wEWN1lBnenGQXV3hr6N/qys9GXyzclZkSodIWZnTBT29tnzMdenydm9Wc3RL5W2Yjg8y 1jzw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=bFccA0HXmiZ501n0BOev0tU7tgm00N7WNvjDMWpXP2c=; fh=tgX2AK6/+Z81/rddcvcR3dD+jyUAFQ7OfCy0nzCarB8=; b=kEHzsPNcO3OgeYFucBv5cFPvi7cyd80KsdINO73smRYNtmONSn5sqrLCjEDplYc0JD FDdcTHNhJsM8GFO9uztH6kWmJONIC+25NNzoVdxGBD98BbFwFJAXp/6rajx3YHLULKBM BmFGJ2Oh6Y/jOxuzqR5kKDvp8WHzOmcer2UX4C35hrcJvt+13K8g+she6hn/S15Wd8ny ptcY4uhCtuIwImA/QcuLXoILe9/tHmh1G+0G/YFNr0F8fKBuhKwTkjUVskPuRBxBebXg GO7upWIDgXW4dHc9CfF5BJzUWoq1INMJRusTjXEcE57bc1radxVCUILHe3OG4rQ1meeY v3Pw==; 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=1775620812; x=1776225612; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=bFccA0HXmiZ501n0BOev0tU7tgm00N7WNvjDMWpXP2c=; b=TJMZz3Pp8Jdc8+lgMeLMzj8hZLkWehXK7xbqaac9wAYbp7tCfTNmFNl0PZd0m7PtbM g3Gp20VL8SdA8foWJlLEzsX2zl5JuFlXsV5RRuGQ4IiOeso4420gErUqwhdD1vQu0ZXx xgRTsbA9kFEeZ530DPOWYisPKXrnuNYo4P8m38ifxF9wnXXbzogkjnStILbVzPavD/ZT BudXdq4Ncd3T/6+QTF78LbfGdctnmzwpTRGLiYf8rwoJBN7GlF5mumF8d6TwfQz9CIMW Ck3qEUVBoVuM0s2dFWWAG+knS3fVXYht8Q2I7rfgToNvdithFnFPa40VwKQQz8f4/bUG v97A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775620812; x=1776225612; h=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=bFccA0HXmiZ501n0BOev0tU7tgm00N7WNvjDMWpXP2c=; b=cDpIh9iIgYSplwakl0IXUZgfMFfcX2jm7yNpCnjOTlunsaBOs/O7dZoceiI3cYxWGu 5htZsLjNd+x4bRO/iAtfcuinrCcs4HxlJsav2DQSDDT2poaJCL1atyeTn+3ebC6QNHRO tid3iS1eWIfwOdGd3OmhLi0d/0qA+ETTtv0SKAkur9R8ZIgQYUbco0JaguW/Al6cfm4B zSLuigqc1nJPRyPdyZ8TRJsDtK/Xfei9OjY/berq1d0KUC/nc7cF+iLXC/tgG94n9vqy 8TZTB14WQfmKDAg419J+NDUTAl6NGgpiTKN5WtQgTRx3150In4f6nf6DChFvVJ45uKBO ZnAA== X-Forwarded-Encrypted: i=1; AJvYcCVw3ZN8R2LNan5AWhq0Np1AP/F9kGpBpR3ijZQnHQeqkIkZiNYkk8qcSSDxHRLbpQylPZx/8nG0+Ae3Pdz0@lists.postgresql.org X-Gm-Message-State: AOJu0YxGiRZ7SS11EpdOOMtnKPPsU2HcizypMDNGK4oKIDfuyk31GxnU 6TkAvVke2nNAxnL7quWqicu9Gw0gwYPQ6b4jhKhJPDWg1cmynaa94MbA57zNc/FSssIjVM7XbQU Hse1/kSuv3cImNUk3ntM83WGEV2es5tJKvXXRkyA= X-Gm-Gg: AeBDies3FLzqHe3rnOS65jz1l9pag8BQeaAsE7uSM39TenWlJYAAx+rvTUCSZezfucb 17eAm/XTCr2/8uFEu8mnJfhdOB3fUFAO5kiaosZOgHN6VqdTXjMCOPuKztMtBh6GdLwmmuIsJfG /fCEuomh0blRHuMOav5sPZ97NKHCBLvMeSijQV3IUnpQQHpycx8FNPtUR3C6mU2ON8ByuWW3/8r xKtad5cPYe/VkEomNHLfnkecZYDCcNLLAD7JA61aJ9YbrCrhQIwxbQSt12/O53spWjXjGlWUQ7k g/LV7vSTAdOVaknH0I89oWp+U92RNlYNeLv6BKE0WpB055Qonh+tag== X-Received: by 2002:a17:903:2282:b0:2b2:489a:f46a with SMTP id d9443c01a7336-2b2819361a1mr196099455ad.36.1775620811724; Tue, 07 Apr 2026 21:00:11 -0700 (PDT) MIME-Version: 1.0 References: <78ff5cc9-268f-4be8-ae0b-c1a07dc24852@proxel.se> In-Reply-To: From: shveta malik Date: Wed, 8 Apr 2026 09:29:59 +0530 X-Gm-Features: AQROBzDYYO1dAlc19j5STzK8UBWFkpCX6u4Be_rcrJCWHwYfzja5DY-C4LtvrO0 Message-ID: Subject: Re: doc: Improve wal_level and effective_wal_level GUC around logical replication To: "David G. Johnston" Cc: Andreas Karlsson , PostgreSQL Hackers , shveta malik Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Few comments: 1) + Running read-only queries on a standby server. Looks incomplete and disconnected from previous sentence. 2) + level used by the system. Namely, whether replica has been promoted to + logical (minimal never promotes). We shall replace replica, logical, minimal with below replica logical minimal Also shall we add 'wal_level'? Otherwise, 'replica' on its own could be understood as a replica server: Namely, whether wal_level replica has been promoted to .... 3) + The parameter reports the actual + level used by the system. Namely, whether replica has been promoted to + logical (minimal never promotes). + This parameter can only be set at server start. "This" here is misleading. Does this refer to wal_level or effective_wal_level? 4) Below that is minimal, Shall we change "that" to replica to avoid any confusion? thanks Shveta