| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Rucha Kulkarni <rirukool(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Doubts regarding pg_freespacemap extension |
| Date: | 2025-02-18 16:21:21 |
| Message-ID: | 5dc74f16-8460-4aa2-9c5a-895698df98e5@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2025-02-18 16:21:33 | Re: Clarification on Role Access Rights to Table Indexes |
| Previous Message | Tom Lane | 2025-02-18 16:02:38 | Re: Clarification on Role Access Rights to Table Indexes |