Hacker News
new
|
past
|
comments
|
ask
|
show
|
jobs
|
submit
login
blackenedgem
on June 12, 2024
|
parent
|
context
|
favorite
| on:
How to get the most out of Postgres memory setting...
I find average leaf density to be the best metric of them all. Most btree indexes with default settings (fill factor 90%) will converge to 67.5% leaf density over time. So anything below that is bloated and a candidate for reindexing.
Consider applying for YC's Fall 2025 batch! Applications are open till Aug 4
Guidelines
|
FAQ
|
Lists
|
API
|
Security
|
Legal
|
Apply to YC
|
Contact
Search: