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