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 1gTpzZ-0005be-DK for pgsql-docs@arkaria.postgresql.org; Mon, 03 Dec 2018 15:18: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 1gTpzX-0005v7-Hx for pgsql-docs@arkaria.postgresql.org; Mon, 03 Dec 2018 15:18:35 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gTpzX-0005v0-A0 for pgsql-docs@lists.postgresql.org; Mon, 03 Dec 2018 15:18:35 +0000 Received: from mail-lf1-x130.google.com ([2a00:1450:4864:20::130]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gTpzU-0005TE-TD for pgsql-docs@lists.postgresql.org; Mon, 03 Dec 2018 15:18:34 +0000 Received: by mail-lf1-x130.google.com with SMTP id l10so9391102lfh.9 for ; Mon, 03 Dec 2018 07:18:32 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=to:from:subject:message-id:date:user-agent:mime-version :content-language; bh=WWmkXL4F1z/vQIr54Vp+7XD4aio0mE9W7FSJsmsAbSw=; b=Z+cWFa9VPlrHfTyatJjK88Lc97Ag6B5dY+iVlN13QFrNb/WWzS8mRvNSaHR+sfXnwp oVZUTeGmTVKofdJQrsWFJN4tNlazcHIYs2T/wx8pXEq5cPOQkVO2ZMX2aYJa+9EbvAgO tGfq+qhdldLp3W6gxi3fxikWvnXGf5BN/ZzjchrX+xC6kB24MXmav5RdCmXLtXHtoJhQ ce/+7zs74DqKnKvpTGoH8ydRLZ/xwccGzGUVXym+/m0WXG4qIUcC4uSd+1yqzQ94WmRB cBVDGcHuBvrP8m1BtAxgI1kRmoXIC0nx+NYt/Qgnspb/Nsy15ADfY4dQ5pB/DKIGEQ6A I2DA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:to:from:subject:message-id:date:user-agent :mime-version:content-language; bh=WWmkXL4F1z/vQIr54Vp+7XD4aio0mE9W7FSJsmsAbSw=; b=kv2igMPMVeV5bnh1CcpVK42tTkoY3HFFQLARKIRrEi4riNElUGAoR+RXLc8umEsr6H qSQjs7qG/nTZY6Vlaq7Prw5ahacskMIYYBuqhap0gmMMtIcXH8MuO6BgpUtCupZsllTn UlTBYhj20R57T2cvhEjGlVcTRZ2iTMiLfHCNzmZcty4nnoCfyTxywEZGQEJFN5j4B6lb WUtbO+fsyuHbzZm/1+kZ/eLZ/cXC1rUXyuPk1szX29Ohz7ElNfqrZqdz7KlpiBLfCW4x ZDInD9I1ER/fldlNikUDGyEqkS0Hnfr9DKNl3RX4cUaNPfCrV5/7flOjnirTRJg+VLxG syAw== X-Gm-Message-State: AA+aEWb1m1H+Sh8eY4V6DhrS4wTzEy7YKWCOTGLGA8HsfVZZlnJY09Qi NlTGfIoUhgfV3snsb/PkdiHkFh+0 X-Google-Smtp-Source: AFSGD/UyqIoLKO4aOZwjA+rP9fpmEK03VK35fUrKd9whp7lwV//Y+wpSpn/CQGY6ko7pmgOwnU0QSQ== X-Received: by 2002:a19:6719:: with SMTP id b25mr8739341lfc.38.1543850311245; Mon, 03 Dec 2018 07:18:31 -0800 (PST) Received: from [192.168.27.213] ([93.174.131.141]) by smtp.gmail.com with ESMTPSA id m21sm2423266lfl.97.2018.12.03.07.18.30 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 03 Dec 2018 07:18:30 -0800 (PST) To: pgsql-docs@lists.postgresql.org From: Maksim Milyutin Subject: Typo in description of replay_lag attribute in pg_stat_replication view Message-ID: <27b3b80c-3615-2d76-02c5-44566b53136c@gmail.com> Date: Mon, 3 Dec 2018 18:18:30 +0300 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.2.1 MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="------------D8DCA468A7B2CE2DE9C07B82" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------D8DCA468A7B2CE2DE9C07B82 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Hello! I have noticed that in description of *flush_lag* in pg_stat_replication view (https://www.postgresql.org/docs/current/monitoring-stats.html#PG-STAT-REPLICATION-VIEW) there exists unknown value of synchronous_commit parameter - *remote_flush*. I think it was meant to use the value *on*. Small patch is attached. -- Regards, Maksim Milyutin --------------D8DCA468A7B2CE2DE9C07B82 Content-Type: text/x-patch; name="flush_lag_fix.patch" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="flush_lag_fix.patch" diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index 4164d84..33869be 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -1856,7 +1856,7 @@ SELECT pid, wait_event_type, wait_event FROM pg_stat_activity WHERE wait_event i notification that this standby server has written and flushed it (but not yet applied it). This can be used to gauge the delay that synchronous_commit level - remote_flush incurred while committing if this + on incurred while committing if this server was configured as a synchronous standby. --------------D8DCA468A7B2CE2DE9C07B82--