Re: doc: explain pgstatindex fragmentation

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Frédéric Yhuel <frederic(dot)yhuel(at)dalibo(dot)com>, Bertrand Drouvot <bertranddrouvot(dot)pg(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Benoit Lobréau <benoit(dot)lobreau(at)dalibo(dot)com>
Subject: Re: doc: explain pgstatindex fragmentation
Date: 2025-01-25 18:07:38
Message-ID: 18420d0c70f6c09dfadcb4c54aebdfe544ab2036.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dmitry Dolgov 2025-01-25 19:46:58 Re: System views for versions reporting
Previous Message Tom Lane 2025-01-25 17:45:34 Re: Set AUTOCOMMIT to on in script output by pg_dump