Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nRT9l-0001cQ-W9 for pgsql-docs@arkaria.postgresql.org; Tue, 08 Mar 2022 06:17:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nRT9k-0001jK-Ny for pgsql-docs@arkaria.postgresql.org; Tue, 08 Mar 2022 06:17:12 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nRT9j-0001jB-RB for pgsql-docs@lists.postgresql.org; Tue, 08 Mar 2022 06:17:12 +0000 Received: from out2-smtp.messagingengine.com ([66.111.4.26]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nRT9e-0001lT-SF for pgsql-docs@lists.postgresql.org; Tue, 08 Mar 2022 06:17:11 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.nyi.internal (Postfix) with ESMTP id 790DA5C02BD; Tue, 8 Mar 2022 01:17:04 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute3.internal (MEProxy); Tue, 08 Mar 2022 01:17:04 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:date:date:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to; s=fm1; bh=QywBcui1uSzBVbhAFJorBmifeTeidbEgZhXZGf M7IeA=; b=Ut022SurXSP8l9Vkwbu16sH1WRFvRmQjskI2lugGom07vzZzrj6dtD dxNrolcrE/7hv29kklERokE2VNHuZ7BKNSx4sN2iVuyaZziMgZn0pzizc1wqgt89 7wzqQQfwW3qsuQnl2k+J5N23yOW+IWofKMHoBoA2TpWLihvQ5Pl9Q85DDhIO4UFZ VvMhZ0jtOsh8W2osQcqQxsG0z5gQkFtDMudB4eEHi8eMNG4w4onSTGngYa8bKSKo gKUSmIJ5gAb+X8zCtx04frDxzEHLPhJzvV45OEQ1DG3rTBgKw0++hXJAYUjlW8OW nUCm2oiZbJsXWH005NM5xYhPikLQhvrA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:date:date:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:sender:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm2; bh=QywBcui1uSzBVbhAF JorBmifeTeidbEgZhXZGfM7IeA=; b=ng1EAKybnCU1dcLr7TgdwGRZNl5TvUdTI f2ebfogbbUBlhoFcqV4wOwn37F2BQGRDcEl39EySHsLM6qfUQSOZ/xT3eOX2zA/o hi+VZNDVeaH34PywuiOgrZCe+v9TUvJfMcZXxzkId2yNYhsFDsPD92vmJfPqdhET 7a0azj6huJdmscn6RKSkqP0qLmYN/VJ/11w3/lgfLDWDMjc8XojjRhqEDhRI1nI1 DYfJ1r/68x6FvT3YEszorF8AjzM/Usw1VukcFiX+HLYROyyTKU21A9RUT0jIImtf jbXvxKW3C3e6Nnw+7rle48xdStazBqMSzqWANAFQ0LGGRZ5Az/3og== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvvddrudduhedgleduucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucgfrhhlucfvnfffucdljedtmdenucfjughrpeffhf fvuffkfhggtggujgesghdtreertddtvdenucfhrhhomhepofhitghhrggvlhcurfgrqhhu ihgvrhcuoehmihgthhgrvghlsehprghquhhivghrrdighiiiqeenucggtffrrghtthgvrh hnpedvgeduuefhtdeuleettdevjeehheeiveeuieegleetgeeljeelieeuieehgeevhfen ucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthh grvghlsehprghquhhivghrrdighiii X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 8 Mar 2022 01:17:03 -0500 (EST) Date: Tue, 8 Mar 2022 15:17:00 +0900 From: Michael Paquier To: Dong Wook Lee Cc: pgsql-docs@lists.postgresql.org Subject: Re: add free space map link in pg_freespacemap page Message-ID: References: <14aeba35c06421ae40c96f3fc31ce998d50dad41.camel@cybertec.at> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="tWiDxdC4NL5LAZie" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --tWiDxdC4NL5LAZie Content-Type: multipart/mixed; boundary="do24wp4/f4dos+Dd" Content-Disposition: inline --do24wp4/f4dos+Dd Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Tue, Mar 08, 2022 at 09:31:49AM +0900, Dong Wook Lee wrote: > I don't know about it, so should I use at FSM for all the > acronyms in the section dedicated to acronyms? Yes, I would do that on consistency grounds. Your idea to add a link to the section describing what a FSM is from pgfreespacemap.sgml is also a good one. While looking around, I have also noticed some inconsistencies within the contents of pageinspect and all that leads me to the patch attached. Does that look fine to you? -- Michael --do24wp4/f4dos+Dd Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="fsm-vm-docs.patch" Content-Transfer-Encoding: quoted-printable diff --git a/doc/src/sgml/pageinspect.sgml b/doc/src/sgml/pageinspect.sgml index 24b5e463ed..55513cf522 100644 --- a/doc/src/sgml/pageinspect.sgml +++ b/doc/src/sgml/pageinspect.sgml @@ -31,9 +31,11 @@ relation and returns a copy as a bytea value. This all= ows a single time-consistent copy of the block to be obtained. fork should be 'main' = for - the main data fork, 'fsm' for the free space map, - 'vm' for the visibility map, or 'init' - for the initialization fork. + the main data fork, 'fsm' for the + free space map, + 'vm' for the + visibility map, or + 'init' for the initialization fork. @@ -136,7 +138,7 @@ test=3D# SELECT page_checksum(get_raw_page('pg_class', = 0), 0); fsm_page_contents shows the internal node struc= ture - of an FSM page. For example: + of an FSM page. For example: test=3D# SELECT fsm_page_contents(get_raw_page('pg_class', 'fsm', 0)); @@ -147,7 +149,7 @@ test=3D# SELECT fsm_page_contents(get_raw_page('pg_clas= s', 'fsm', 0)); See src/backend/storage/freespace/README for mo= re - information on the structure of an FSM page. + information on the structure of an FSM page. diff --git a/doc/src/sgml/pgfreespacemap.sgml b/doc/src/sgml/pgfreespacemap= =2Esgml index 5025498249..1f7867d9b9 100644 --- a/doc/src/sgml/pgfreespacemap.sgml +++ b/doc/src/sgml/pgfreespacemap.sgml @@ -9,10 +9,10 @@ =20 The pg_freespacemap module provides a means for exa= mining the - free space map (FSM). It provides a function called - pg_freespace, or two overloaded functions, to be - precise. The functions show the value recorded in the free space map for - a given page, or for all pages in the relation. + free space map (FSM). + It provides a function called pg_freespace, or two + overloaded functions, to be precise. The functions show the value record= ed in + the free space map for a given page, or for all pages in the relation. =20 @@ -36,7 +36,7 @@ Returns the amount of free space on the page of the relation, specif= ied - by blkno, according to the FSM. + by blkno, according to the FSM. @@ -50,7 +50,8 @@ Displays the amount of free space on each page of the relation, - according to the FSM. A set of (blkno bigint, avail int2) + according to the FSM. A set of + (blkno bigint, avail int2) tuples is returned, one tuple for each page in the relation. @@ -112,8 +113,8 @@ postgres=3D# SELECT * FROM pg_freespace('foo', 7); =20 Original version by Mark Kirkwood markir@paradise.net.nz. - Rewritten in version 8.4 to suit new FSM implementation by Heikki - Linnakangas heikki@enterprisedb.com + Rewritten in version 8.4 to suit new FSM implementat= ion + by Heikki Linnakangas heikki@enterprisedb.com =20 diff --git a/doc/src/sgml/storage.sgml b/doc/src/sgml/storage.sgml index 7136bbe7a3..f4b9f66589 100644 --- a/doc/src/sgml/storage.sgml +++ b/doc/src/sgml/storage.sgml @@ -603,10 +603,11 @@ tuple would otherwise be too big. =20 Each heap and index relation, except for hash indexes, has a Free Space Map -(FSM) to keep track of available space in the relation. It's stored -alongside the main relation data in a separate relation fork, named after = the -filenode number of the relation, plus a _fsm suffix. Fo= r example, -if the filenode of a relation is 12345, the FSM is stored in a file called +(FSM) to keep track of available space in the relation. +It's stored alongside the main relation data in a separate relation fork, +named after the filenode number of the relation, plus a _fsm +suffix. For example, if the filenode of a relation is 12345, the +FSM is stored in a file called 12345_fsm, in the same directory as the main relation= file. =20 --do24wp4/f4dos+Dd-- --tWiDxdC4NL5LAZie Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmIm9NwACgkQnvQgOdby QH0fpg/+IWxF/FDvPdoBoGHquPkLEGsLQRiA63cz2QZ+UdNLssrTUNLoM+nc9xIM mx/85hvCPlJYxoCZWpI02F5lTOgVkMS8WJzxMnZ+tfeMMnRe/QQPk/gl31JWa3PT iAV1BsusEAXUdFwhPTX/BTexyTC3zASodGBR9i9cOQbAHD8o3Y3kAy9uIiaSCQ9r TAyc+vWbgsOT7bRG0ep/QJb4IQzZ9MfngbLGG3CHMCuE0vc/pJhJJ1Ysfkkbp0a+ tUv98WvMEYtLguGJkFpCajDWbzesUSTzLZKvqJy33ah2dr+R2H8ULC0l/WH4cbQO 5fcP4I7p/6UMrXxbE6xUq2iwHRiAJ/S+Rn5FxBSgwjR4ZQU9QaKfTXblgaItRvFw 2NoDYcKvNqerzpvuvtlA5Mbi+J8RoIKmGicAS6IbQM50aZMZA5nf1m902lN3saCE 9HKSjcLai29BeokJ9RMSiqMzRsVTefen4SeODquywN7FK7JAB8aD3Wr2zzxhi/V2 q+lpADy1F2FTrDoRuJnayVqxY8pK5H++lFxV6rWOxsbuqQvE2arvmh+DF86qHT/5 YWpNvXzXF07ve2SEaS3D7mCAKmNrpyv6Kfg+EeG70JzzOqQpGXylsLhACcKtUmSw KpTreYOnnghe6uQ88DH/b+G0mKtVsDRiTTw5CLj92lZUilX9eb8= =79f6 -----END PGP SIGNATURE----- --tWiDxdC4NL5LAZie--