doc: explain pgstatindex fragmentation - Mailing list pgsql-hackers

From Benoit Lobréau
Subject doc: explain pgstatindex fragmentation
Date
Msg-id 4c5dee3a-8381-4e0f-b882-d1bd950e8972@dalibo.com
Whole thread Raw
List 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



pgsql-hackers by date:

Previous
From: Nathan Bossart
Date:
Subject: Re: Pre-allocating WAL files
Next
From: Nathan Bossart
Date:
Subject: Re: Pre-allocating WAL files