Re: Doubts regarding pg_freespacemap extension - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Doubts regarding pg_freespacemap extension
Date
Msg-id 5dc74f16-8460-4aa2-9c5a-895698df98e5@aklaver.com
Whole thread Raw
In response to Doubts regarding pg_freespacemap extension  (Rucha Kulkarni <rirukool@gmail.com>)
List pgsql-general
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




pgsql-general by date:

Previous
From: Bowen Shi
Date:
Subject: Re: pg_rewind - enable wal_log_hints or data-checksums
Next
From: dfgpostgres
Date:
Subject: How to select avg(select max(something) from ...)