Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gUJ7N-0007wx-7T for pgsql-docs@arkaria.postgresql.org; Tue, 04 Dec 2018 22:24:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gUJ7K-0002ik-LU for pgsql-docs@arkaria.postgresql.org; Tue, 04 Dec 2018 22:24:34 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gUJ7K-0002id-AN for pgsql-docs@lists.postgresql.org; Tue, 04 Dec 2018 22:24:34 +0000 Received: from mail-lf1-x12a.google.com ([2a00:1450:4864:20::12a]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gUJ7C-0002GV-Qp for pgsql-docs@lists.postgresql.org; Tue, 04 Dec 2018 22:24:32 +0000 Received: by mail-lf1-x12a.google.com with SMTP id p6so13213001lfc.1 for ; Tue, 04 Dec 2018 14:24:26 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:cc:references:from:message-id:date:user-agent :mime-version:in-reply-to:content-transfer-encoding:content-language; bh=kyu+L+ARhQvTEleJSxb0aeN/KoAehMx2M4hXAjmb2Uo=; b=q7jwHuXL46roraN5hFwWTBxbTgRCAIk1yRXKAWIkHMx6JdnVoBuoTGQRk/AEF3ApeW NUDNvIWRUMe0l+0tgGNDmO7WkRR1AqQnvSb8Ns8dA4bvBsa96n+KdWiblo5d3zFZ4R4Q yf74N7NwxH+L3oDtKAevOFRJ0AIoe3ealCu3aFMpRDVFZ/JhF9faca6S2rhxqxqXhzmL oYLTop8YdJ4Ly8iey3rAK8jqmME57fqDA3eQxm7XUhUP9fV8PZgjl2/LRRAokKFvGCYv Gv47/Vf7Ek2snROV+pBZ5Zh0gIevZY4DV+FXR8q6engJM5sc5CX/1ajvW9JbSI4f61br xGJQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:cc:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=kyu+L+ARhQvTEleJSxb0aeN/KoAehMx2M4hXAjmb2Uo=; b=fGNRQ/+w7PefSKo0YEu5HCiz6Vk3TipoUNk51R1REw6bpGBY4cVvPYkDS6oYF1cRBr moNlBedjCnoT6p8bPTC73ZOUQ+fO74mwUkMM2VWD6OT093OujFKFrZ1BEZ5ShsT8evBe 4GgOickUJvhb4D3KN7I5e0yEfzhQiXm1mEtYHfDQ1YSQffSw7W6pixBBy8BH6gOI6Tcd YSjTZVaJly1s6oFrLSC8kRrPPO7fdd42XRv6MwQE0RepgwRX7JBj2aHwWRgsN5QlxWl7 7lYxQ/OdrZ5hHW23I3JKP5vS1WzlIwygKhr5lWGg6QChN6MuW4h+DMDV5PkwDswt4M/m 2xVw== X-Gm-Message-State: AA+aEWZ0IINxK00f4Ip+0jB9z5J1x416aNTAo2jj0/k4+40/yjPLE7QY mUAvyXll4VbB4wy+J1YiCgs0Hv8G+Ss= X-Google-Smtp-Source: AFSGD/WJdtiBKcHUN1JHOJow6eqE+HMgTjOgZsfQC2IOB91J850EnzANQ71M7uxXmeUbuiTDLGbfYQ== X-Received: by 2002:a19:6806:: with SMTP id d6mr12416561lfc.48.1543962264342; Tue, 04 Dec 2018 14:24:24 -0800 (PST) Received: from MacBook-Pro-Milutin.local ([188.123.230.226]) by smtp.gmail.com with ESMTPSA id e14-v6sm3286977ljb.31.2018.12.04.14.24.23 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Tue, 04 Dec 2018 14:24:23 -0800 (PST) Subject: Re: Typo in description of replay_lag attribute in pg_stat_replication view To: Michael Paquier , Thomas Munro Cc: pgsql-docs@lists.postgresql.org References: <27b3b80c-3615-2d76-02c5-44566b53136c@gmail.com> <20181204001802.GK3423@paquier.xyz> <20181204021925.GM3423@paquier.xyz> From: Maksim Milyutin Message-ID: <0cfde408-a360-3461-124c-cfa0c72e3b0d@gmail.com> Date: Wed, 5 Dec 2018 01:24:22 +0300 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:60.0) Gecko/20100101 Thunderbird/60.3.1 MIME-Version: 1.0 In-Reply-To: <20181204021925.GM3423@paquier.xyz> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 04.12.2018 5:19, Michael Paquier wrote: > On Tue, Dec 04, 2018 at 01:28:15PM +1300, Thomas Munro wrote: >> On Tue, Dec 4, 2018 at 1:18 PM Michael Paquier wrote: >>> Yes, you are right. It should be "on" as "remote_flush" is not a valid >>> value. remote_flush is listed in SyncCommitLevel though, so this makes >>> me wonder if we should also introduce a new value for this purpose >>> available for users. The fix you propose looks good to me. Any >>> opinions from others? >> +1 for the patch. > Thanks for confirming, Thomas. I'll go apply hopefully tomorrow if > nobody has objections. > >> As for introducing remote_flush as the true name of the level, this >> was discussed but somehow went off-course and never made it to the >> finish line: >> >> https://www.postgresql.org/message-id/flat/CAEepm%3D3FFaanSS4sugG%2BApzq2tCVjEYCO2wOQBod2d7GWb%3DDvA%40mail.gmail.com > Oh, I forgot this one. We may want to revive that... remote_flush is > more meaningful than on, especially since there are more and more > possible values for synchronous_commit. Yeah, I think the notion *remote_flush level* is more appropriate especially in the context of sync replication. Within this context maybe it makes sense to replace the word *level* to *value* in description of *flush_lag*? -- Regards, Maksim Milyutin