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@xxxxxxxxxxx