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>, Bertrand Drouvot <bertranddrouvot.pg@gmail.com>

Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, Benoit Lobréau <benoit.lobreau@dalibo.com>

Date: 2025-01-25T18:07:38Z

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

On Fri, 2025-01-24 at 15:41 +0100, Frédéric Yhuel wrote:
> v4 attached

Looks good to me.  I have one question left: the explanation for the performance
penalty of a high leaf fragmentation sounds like it would only be relevant for
disks where sequential reads are faster.  If that is correct, perhaps it would be
worth mentioning.

Yours,
Laurenz Albe