Gregory Smith (@postgresperf) 's Twitter Profile
Gregory Smith

@postgresperf

#PostgreSQL startup founder @crunchydata, author, lapsed #planetpostgresql blogger. Family advocate for #MyalgicEncephalomyelitis #POTS #PwME #MEcfs patients.

ID: 370215554

calendar_today08-09-2011 17:05:26

215 Tweet

458 Followers

95 Following

Gregory Smith (@postgresperf) 's Twitter Profile Photo
Gregory Smith
@postgresperf

9 months ago

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…