pgeoghegan.blogspot.com 23. 3. 2019Visualizing Postgres page images within GDB – pgeoghegan.blogspot.com 19. 5. 2018Visualizing a column's space overhead using pg_hexedit – pgeoghegan.blogspot.com 20. 3. 2018Decoding pg_filenode.map files with pg_filenodemapdata – pgeoghegan.blogspot.com 8. 1. 2018Exploring SP-GiST and BRIN indexes visually using pg_hexedit – pgeoghegan.blogspot.com 15. 12. 2017pg_hexedit now supports GiST, GIN, and hash indexes – pgeoghegan.blogspot.com 27. 11. 2017pg_hexedit: Rich hex editor annotations for Postgres relfiles – pgeoghegan.blogspot.com 26. 10. 2017amcheck “table-matches-index” enhancement now available, detects "freeze-the-dead" corruption – pgeoghegan.blogspot.com 16. 10. 2017amcheck for Postgres 9.4+ now available from PGDG apt and yum repositories – pgeoghegan.blogspot.com 19. 7. 2017PostgreSQL Index bloat under a microscope – pgeoghegan.blogspot.com 10. 5. 2016amcheck: Verify the logical consistency of PostgreSQL B-Tree indexes – pgeoghegan.blogspot.com 14. 11. 2015Suggesting a corrected column name/spelling in the event of a column misspelling – pgeoghegan.blogspot.com 2. 10. 2015Avoid naming a constraint directly when using ON CONFLICT DO UPDATE – pgeoghegan.blogspot.com 4. 4. 2015Abbreviated keys for numeric to accelerate numeric sorts – pgeoghegan.blogspot.com 24. 1. 2015Abbreviated keys: exploiting locality to improve PostgreSQL's text sort performance – pgeoghegan.blogspot.com 24. 3. 2014What I think of jsonb – pgeoghegan.blogspot.com 21. 1. 2013Moving on – pgeoghegan.blogspot.com 4. 12. 2012Finding plans in pg_stat_plans easily with pg_find_plans – pgeoghegan.blogspot.com 16. 11. 2012Notes on index-only scans – pgeoghegan.blogspot.com 20. 10. 2012First release of pg_stat_plans – pgeoghegan.blogspot.com 2. 8. 2012Sorting improvements in PostgreSQL 9.2: the case for micro-optimisation – pgeoghegan.blogspot.com 4. 6. 2012Towards 14,000 write transactions per second on my laptop – pgeoghegan.blogspot.com 29. 3. 2012Much improved statement statistics coming to Postgres 9.2 – pgeoghegan.blogspot.com 29. 1. 2012Power consumption in Postgres 9.2 – pgeoghegan.blogspot.com 6. 8. 2011Clang now builds Postgres without additional warnings – pgeoghegan.blogspot.com 28. 7. 2011Could Clang displace GCC generally? Part II: Performance of PostgreSQL binaries – pgeoghegan.blogspot.com
23. 3. 2019Visualizing Postgres page images within GDB – pgeoghegan.blogspot.com 19. 5. 2018Visualizing a column's space overhead using pg_hexedit – pgeoghegan.blogspot.com 20. 3. 2018Decoding pg_filenode.map files with pg_filenodemapdata – pgeoghegan.blogspot.com 8. 1. 2018Exploring SP-GiST and BRIN indexes visually using pg_hexedit – pgeoghegan.blogspot.com 15. 12. 2017pg_hexedit now supports GiST, GIN, and hash indexes – pgeoghegan.blogspot.com 27. 11. 2017pg_hexedit: Rich hex editor annotations for Postgres relfiles – pgeoghegan.blogspot.com 26. 10. 2017amcheck “table-matches-index” enhancement now available, detects "freeze-the-dead" corruption – pgeoghegan.blogspot.com 16. 10. 2017amcheck for Postgres 9.4+ now available from PGDG apt and yum repositories – pgeoghegan.blogspot.com 19. 7. 2017PostgreSQL Index bloat under a microscope – pgeoghegan.blogspot.com 10. 5. 2016amcheck: Verify the logical consistency of PostgreSQL B-Tree indexes – pgeoghegan.blogspot.com 14. 11. 2015Suggesting a corrected column name/spelling in the event of a column misspelling – pgeoghegan.blogspot.com 2. 10. 2015Avoid naming a constraint directly when using ON CONFLICT DO UPDATE – pgeoghegan.blogspot.com 4. 4. 2015Abbreviated keys for numeric to accelerate numeric sorts – pgeoghegan.blogspot.com 24. 1. 2015Abbreviated keys: exploiting locality to improve PostgreSQL's text sort performance – pgeoghegan.blogspot.com 24. 3. 2014What I think of jsonb – pgeoghegan.blogspot.com 21. 1. 2013Moving on – pgeoghegan.blogspot.com 4. 12. 2012Finding plans in pg_stat_plans easily with pg_find_plans – pgeoghegan.blogspot.com 16. 11. 2012Notes on index-only scans – pgeoghegan.blogspot.com 20. 10. 2012First release of pg_stat_plans – pgeoghegan.blogspot.com 2. 8. 2012Sorting improvements in PostgreSQL 9.2: the case for micro-optimisation – pgeoghegan.blogspot.com 4. 6. 2012Towards 14,000 write transactions per second on my laptop – pgeoghegan.blogspot.com 29. 3. 2012Much improved statement statistics coming to Postgres 9.2 – pgeoghegan.blogspot.com 29. 1. 2012Power consumption in Postgres 9.2 – pgeoghegan.blogspot.com 6. 8. 2011Clang now builds Postgres without additional warnings – pgeoghegan.blogspot.com 28. 7. 2011Could Clang displace GCC generally? Part II: Performance of PostgreSQL binaries – pgeoghegan.blogspot.com