What is acceptable level of BTree index fragmentation in Postgres?
1
vote
2
answers
1083
views
I wonder at which point it makes sense to rebuild BTree index on relatively large tables (couple hundred GB).
To me anything above 30% or 40% appears to be a good candidate, but I saw some say even 70% is not too bad for Postgres. I'm getting fragmentation from
pgstattuple.pgstatindex
function if it matters.
Asked by a1ex07
(9060 rep)
Sep 8, 2023, 10:09 PM
Last activity: Feb 16, 2025, 09:51 PM
Last activity: Feb 16, 2025, 09:51 PM