Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dUCIo-0004m4-Pg for pgsql-docs@arkaria.postgresql.org; Sun, 09 Jul 2017 13:31:10 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dUCIn-0000LU-9a for pgsql-docs@arkaria.postgresql.org; Sun, 09 Jul 2017 13:31:09 +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_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dUCIl-0000LC-Pf for pgsql-docs@postgresql.org; Sun, 09 Jul 2017 13:31:07 +0000 Received: from mail-wr0-x22f.google.com ([2a00:1450:400c:c0c::22f]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1dUCIc-0006Jv-S4 for pgsql-docs@postgresql.org; Sun, 09 Jul 2017 13:31:06 +0000 Received: by mail-wr0-x22f.google.com with SMTP id r103so105001712wrb.0 for ; Sun, 09 Jul 2017 06:30:58 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=to:from:subject:organization:message-id:date:user-agent :mime-version:content-language; bh=L+TmfMQ/Fkqo2dk5v63VbSjGm/sSeinNn4mcH0Fa/DU=; b=pF/PCkIywmr+2ONv5HEkUP4XTKmysVoxJQrB1jlkuzhZfHmIgSlcgByOlPBbFE5oJL bicxUTOSP3VZkXRG+T14cZJe3SlTZs7gorImTQOY4ZikzwosCKyBIQrousG9RyVIAWfA qWRgNgN7VzVw+PxGdWCBl6AXSjR3aI4Axvs3+biJbME+L8SaRQ4cAlQ/tch+5VnHLwzr JlSuMMF1etMU4WVIKQAaVa8khxa8JcGV2dDpmdSoNe/LutuKFKfo276mJNwF96AIlwqx cAvYGtt4K8DrM9FczJ93SiFEf45g3GyvOt5X0vj4pATPp98vkhQOZO9MAe4/0CgZfzf4 cwwA== 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:organization:message-id:date :user-agent:mime-version:content-language; bh=L+TmfMQ/Fkqo2dk5v63VbSjGm/sSeinNn4mcH0Fa/DU=; b=AN+z7LtpUdwKkHyGdnxngSCvM7nSAUi6l8nuhJeE6yAskE8GVIk7Y+NVxAKOqGVlE7 8pyVQyLI/dod8O1ZjFw5VCg5thp2ednddLj02vqnbEnTryozw6Z6JM029yQ1bcca9wxP wICzmU4rJS/S7e8LYLL76u4Ndkys9gLf4Sm4xX5kCkNddryeyYhbRRUzxIiAunZX22AF Z/wpfj1q4I0m3CkgLUvmbn5X6MPGJ29msxgwSc0Way06r91McbCeMrBZY3h2YdyTUuXQ m0Vkpkvl/HgckzPJmvo2C4yn72x3c63acIl07jnCy8UBteWs8i0adAztSXjdbV0k12Xj WtlA== X-Gm-Message-State: AIVw111Ku7GC3LJRR9IOBw5VNSgkRoYcdjr/OhQkb/1/+maZ47YBRfjs 2ENKuocGorLFTmj6UgBOo2ru9R9Jl6LpBjUZogrbJdFdP6bRfMqgOnHGg9iYts1qDxvZhz7q6sA 13kf72zJGAKsqUvXKP47y84OeRfosbbMhYfdnHrRHoZZYve8Ho0VXyKHx5+O5kk+6N4qRG+dO X-Received: by 10.28.213.205 with SMTP id m196mr4277564wmg.109.1499607056365; Sun, 09 Jul 2017 06:30:56 -0700 (PDT) Received: from [192.168.0.3] (ath91-3-88-167-161-184.fbx.proxad.net. [88.167.161.184]) by smtp.gmail.com with ESMTPSA id w96sm7362241wrc.33.2017.07.09.06.30.55 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Sun, 09 Jul 2017 06:30:55 -0700 (PDT) To: pgsql-docs@postgresql.org From: Vik Fearing Subject: No, that's backwards. Organization: 2ndQuadrant France Message-ID: Date: Sun, 9 Jul 2017 15:30:54 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.1.1 MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="------------C716529651866A63CC793A82" Content-Language: en-US List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org This is a multi-part message in MIME format. --------------C716529651866A63CC793A82 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit The documentation at https://www.postgresql.org/docs/current/static/storage-vm.html says that the visibility map "keeps track of which pages contain only unfrozen tuples". This is wrong; it keeps track of all-frozen pages not all-unfrozen. Trivial patch attached. -- Vik Fearing +33 6 46 75 15 36 http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support --------------C716529651866A63CC793A82 Content-Type: text/x-patch; name="unfrozen.patch" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="unfrozen.patch" diff --git a/doc/src/sgml/storage.sgml b/doc/src/sgml/storage.sgml index a156693ec8..aed2cf8bca 100644 --- a/doc/src/sgml/storage.sgml +++ b/doc/src/sgml/storage.sgml @@ -630,7 +630,7 @@ can be used to examine the information stored in free space maps. Each heap relation has a Visibility Map (VM) to keep track of which pages contain only tuples that are known to be visible to all active transactions; it also keeps track of which pages contain -only unfrozen tuples. It's stored +only frozen tuples. It's stored alongside the main relation data in a separate relation fork, named after the filenode number of the relation, plus a _vm suffix. For example, if the filenode of a relation is 12345, the VM is stored in a file called --------------C716529651866A63CC793A82 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs --------------C716529651866A63CC793A82--