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.94.2) (envelope-from ) id 1tkQLh-003nw5-Gg for pgsql-general@arkaria.postgresql.org; Tue, 18 Feb 2025 16:21:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tkQLg-00BxhW-7X for pgsql-general@arkaria.postgresql.org; Tue, 18 Feb 2025 16:21:28 +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.94.2) (envelope-from ) id 1tkQLf-00BxOH-0S for pgsql-general@lists.postgresql.org; Tue, 18 Feb 2025 16:21:27 +0000 Received: from fhigh-b8-smtp.messagingengine.com ([202.12.124.159]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tkQLc-001XyK-0s for pgsql-general@lists.postgresql.org; Tue, 18 Feb 2025 16:21:25 +0000 Received: from phl-compute-02.internal (phl-compute-02.phl.internal [10.202.2.42]) by mailfhigh.stl.internal (Postfix) with ESMTP id 1E15F254010E; Tue, 18 Feb 2025 11:21:23 -0500 (EST) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-02.internal (MEProxy); Tue, 18 Feb 2025 11:21:23 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:content-transfer-encoding:content-type:content-type:date:date :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm2; t=1739895682; x=1739982082; bh=P/hBVHENs/SjP/BWin2If9uaDlEqM2RohjL56K26Lxs=; b= ULNL2DiOkpx3PdpffYD5FpfrgKtyA2EjdhBoib7i5jyC4EEVUVIP1u7Rw9mHJCgc 9IKg/aGBKYuT/ITz4NhBdZ3JMyJ7sVe2PbqhmgcyLBujggpKByEL5LscPT/bQsOE TB7Y8HeCeCszEbjAo5Ws6hsEqcYoqwwLF3WdDe9Y5h9Yay4ZaJH/yAR1KcxIt24k i+4nsn+74kIUjdU3huquUGS17AgfIHYTym5uhT/PZ3enkjCo/FGdQ9SQO718wOsW /QT/oZNGffMuVPVTdFpCSJ7wFoNhgF8ScxXsqssij1kOQVnKCxq98wR2bxr1P5oX mjC8aj5EK8CqZ7gRaU6M5w== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm3; t=1739895682; x=1739982082; bh=P /hBVHENs/SjP/BWin2If9uaDlEqM2RohjL56K26Lxs=; b=k9VZZsEyTAC9gGgZq 4fBQ/KiFhAEqMaGzaZEqFs0PIqd7wyt4amJlaU3GYA9/8PsLnUyV2ptDD1HLhF0X MjOH8dbQsPq7Jed+EVGobYUDbT1iI8AFN1JL5LZ5OZyAJ+VqIN9xOo8c17WAUfm8 QjqyObvlZc+X1+9Ki4uiOzfkYxFfHu2u6NyDZfuNrKZXFYHnski0YId1aZpKkVTL lINRJV+OBTU5qNeoPQqrXxFQ18untp49HnsPRc4PeozZ8IJICLpJxrFoKO9NWlZY Yi19TWaQy6/FLDk4q2vkm+AjU+Eu2I4Uj7p3Oq58TcCgUlkpnjGzvDGQ3GmNGRpX P997w== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgdeiudejkecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpggftfghnshhusghstghrihgsvgdp uffrtefokffrpgfnqfghnecuuegrihhlohhuthemuceftddtnecunecujfgurhepkfffgg gfuffvfhfhjggtgfesthejredttddvjeenucfhrhhomheptegurhhirghnucfmlhgrvhgv rhcuoegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhmqeenucggtffrrg htthgvrhhnpeekfeehuddvjeeigfeifeejtdduudffledvfeelheeftdeiffeugfdvkeel gedtvdenucffohhmrghinhepphhoshhtghhrvghsqhhlrdhorhhgnecuvehluhhsthgvrh fuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprggurhhirghnrdhklhgrvhgv rhesrghklhgrvhgvrhdrtghomhdpnhgspghrtghpthhtohepvddpmhhouggvpehsmhhtph houhhtpdhrtghpthhtoheprhhirhhukhhoohhlsehgmhgrihhlrdgtohhmpdhrtghpthht ohepphhgshhqlhdqghgvnhgvrhgrlheslhhishhtshdrphhoshhtghhrvghsqhhlrdhorh hg X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 18 Feb 2025 11:21:22 -0500 (EST) Message-ID: <5dc74f16-8460-4aa2-9c5a-895698df98e5@aklaver.com> Date: Tue, 18 Feb 2025 08:21:21 -0800 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Doubts regarding pg_freespacemap extension To: Rucha Kulkarni , pgsql-general@lists.postgresql.org References: Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2/17/25 07:12, Rucha Kulkarni wrote: > Hi PostgreSQL Community, > > While exploring the pg_freespacemap extension, I came across a few > doubts and would appreciate any insights or clarifications: > > > 3. Whenever I check the values for B-tree indexes, I observe all values > to be 0. From here: https://www.postgresql.org/docs/current/pgfreespacemap.html "For indexes, what is tracked is entirely-unused pages, rather than free space within pages. Therefore, the values are not meaningful, just whether a page is full or empty." > > Regards, > > Rucha Kulkarni > -- Adrian Klaver adrian.klaver@aklaver.com