Horton
Menu

Thread

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

  1. doc: explain pgstatindex fragmentation

    Benoit Lobréau <benoit.lobreau@dalibo.com> — 2025-01-21T16:01:06Z

    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

  2. Re: doc: explain pgstatindex fragmentation

    Benoit Lobréau <benoit.lobreau@dalibo.com> — 2025-01-22T09:24:33Z

    Here is an updated patch to save you some time.

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

  3. Re: doc: explain pgstatindex fragmentation

    Frédéric Yhuel <frederic.yhuel@dalibo.com> — 2025-01-22T09:56:43Z

    
On 1/22/25 10:24, Benoit Lobréau wrote:
> Here is an updated patch to save you some time.

Thanks ! it does seems better that way.