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…
github.com
GitHub - CrunchyData/pg_goggles: pg_goggles provides better scaled and summarized views into...
pg_goggles provides better scaled and summarized views into PostgreSQL's cryptic internal counters. - CrunchyData/pg_goggles
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. FINALLY DID IT 515K posts
- 2. The PENGU 220K posts
- 3. The AAVE 199K posts
- 4. Happy Festivus 2,015 posts
- 5. Christmas Eve Eve 52.7K posts
- 6. Good Tuesday 32.2K posts
- 7. #tuesdayvibe 2,348 posts
- 8. Mainz Biomed N.V. N/A
- 9. Tennis 20.7K posts
- 10. Carry Water 1,211 posts
- 11. Chop Wood N/A
- 12. Larry Nassar 9,260 posts
- 13. Greenland 109K posts
- 14. Soccer 26.9K posts
- 15. #elixir 2,504 posts
- 16. #SFxJimmySeaAvocean 155K posts
- 17. JSCEAN FAMSCREEN 141K posts
- 18. #albatross 3,337 posts
- 19. US GDP 8,847 posts
- 20. Q3 GDP 6,262 posts
Something went wrong.
Something went wrong.