Re: doc: explain pgstatindex fragmentation

Laurenz Albe <laurenz.albe@cybertec.at>

From: Laurenz Albe <laurenz.albe@cybertec.at>

To: Frédéric Yhuel <frederic.yhuel@dalibo.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2025-01-23T13:52:03Z

Lists: pgsql-hackers

Commits

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

doc: explain pgstatindex fragmentation
- 960135114629 19 (unreleased) landed

Attachments

v2-0001-doc-explain-pgstatindex-fragmentation.patch (text/x-patch) patch v2-0001

On Tue, 2024-11-05 at 18:36 +0100, Frédéric Yhuel wrote:
> Hi, I thought it would be nice to give the user a better idea of what 
> avg_leaf_density and leaf_fragmentation mean.
> 
> Patch attached. What do you think?

I am all for explaining this better.

Here is my take.  I tried to avoid "bloat", since it is jargon that
not everybody might be familiar with.  I also didn't start a new
paragraph and kept it together with the explanation for index_size.

Yours,
Laurenz Albe