doc: explain pgstatindex fragmentation

From: Benoit Lobréau <benoit(dot)lobreau(at)dalibo(dot)com>
To: Frédéric Yhuel <frederic(dot)yhuel(at)dalibo(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: doc: explain pgstatindex fragmentation
Date: 2025-01-21 16:01:06
Message-ID: 4c5dee3a-8381-4e0f-b882-d1bd950e8972@dalibo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I like the clarification but I think that:

A higher <literal>leaf_fragmentation</literal> indicates that the
physical order of the index leaf
pages increasingly deviates from their logical order.

Would be cleaner than:

The higher <literal>leaf_fragmentation</literal> is, the less the
physical order
of the index leaf pages corresponds to the logical order we would have
just after
a <command>REINDEX</command>.

--
Benoit Lobréau
Consultant
http://dalibo.com

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Nathan Bossart 2025-01-21 16:13:14 Re: Pre-allocating WAL files
Previous Message Nathan Bossart 2025-01-21 15:52:51 Re: Pre-allocating WAL files