Re: pgstattuple extension for indexes

Hi Nagayasu san and folks,
I have a question about pgstatindex.

Satoshi Nagayasu <nagayasus@nttdata.co.jp> wrote:

> Attached patch has been cleaned up,
> and modified to be able to work with CVS HEAD.

Index leaf pages are ordered just after REINDEX. [1] [2] [3]
After full-split, they will be the following: [1] [3] [5] [2] [4] [6]
because new pages are allocated at the end of the index file.

I think this condition should be regarded as full-fragmented,
but pgstatindex reports that the leaf_fragmentation is 50%.


Presently, fragmentation factor is computed as the code below:
   if (opaque->btpo_next != P_NONE && opaque->btpo_next < blkno)       stat->fragments++;

But the method has the above problem. So I suggest to use whether
the right link points to the next adjacent page or not.
   if (opaque->btpo_next != P_NONE && opaque->btpo_next != blkno + 1)       stat->fragments++;

Do you think which method is better? Or do you have other ideas?

Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center