Postgres Pro
Downloads
Home   >   mailing lists

Re: doc: explain pgstatindex fragmentation - Mailing list pgsql-hackers

From Laurenz Albe
Subject Re: doc: explain pgstatindex fragmentation
Date
Msg-id 18420d0c70f6c09dfadcb4c54aebdfe544ab2036.camel@cybertec.at
Whole thread Raw
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Set AUTOCOMMIT to on in script output by pg_dump
Next
From: Tom Lane
Date:
Subject: Re: Why we need to check for local buffers in BufferIsExclusiveLocked and BufferIsDirty?