Horton
Menu

doc: explain pgstatindex fragmentation

Benoit Lobréau <benoit.lobreau@dalibo.com>

View thread
From: Benoit Lobréau <benoit.lobreau@dalibo.com>
To: Frédéric Yhuel <frederic.yhuel@dalibo.com>
Cc: pgsql-hackers@lists.postgresql.org
Date: 2025-01-21T16:01:06Z
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

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. doc: explain pgstatindex fragmentation