During index tinkering I save a snapshot of the index stats and/or run pg_stat_reset, make the change, and then monitor the new block rate of I/O to the indexes. The index block read stats show the new hot and dead spots. My WIP catalog query samples: github.com/CrunchyData/pg…
Three things to remember about Postgres indexes: 1) Indexes can speed up operations for a query that SELECT * for a column but they can also make other query functions joins, sorting (ORDER BY) and grouping (GROUP BY) faster. 2) Creating an index on a column doesn't guarantee…
United States Trends
- 1. Pro Bowl 21.3K posts
- 2. The AsterDEX 45.8K posts
- 3. Happy Festivus 3,330 posts
- 4. Christmas Eve Eve 64.8K posts
- 5. FINALLY DID IT 565K posts
- 6. Ben Sasse 1,060 posts
- 7. Cam Jurgens N/A
- 8. #AvengersDoomsday 133K posts
- 9. Steve Rogers 15.7K posts
- 10. #NXXTHelpsSF N/A
- 11. The PENGU 220K posts
- 12. Happy Holidays 110K posts
- 13. Jordan Davis 1,029 posts
- 14. NextNRG Inc N/A
- 15. Larry Nassar 19.9K posts
- 16. Joe Alt N/A
- 17. The AAVE 199K posts
- 18. Jalen Carter N/A
- 19. Derrick Brown N/A
- 20. Soccer 28.5K posts
Loading...
Something went wrong.
Something went wrong.