Sample Header Ad - 728x90

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