cjolly

newpg=9.6.1 # set to new PG version number
oldpg=`pg_config --version | cut -d' ' -f2`

# PG 96. upgrades the readline to v7, which breaks anything linked against readline v6, like ruby via ruby-build. 
# I *think* this should prevent it from installing v7. But if weird shit happens with various rubies, 
# you'll have to reinstall them.
brew pin readline

# Stop current Postgres server
brew services stop postgresql

next2you

        SELECT idx.relname as table,
               idx.indexrelname as index,
               pg_relation_size( idx.indexrelname::text )/1024/1024 as bytes,
               cls.relpages as pages,
               cls.reltuples as tuples,
               idx.idx_scan as scanned,
               idx.idx_tup_read as read,
               idx.idx_tup_fetch as fetched
          FROM pg_stat_user_indexes idx,
               pg_class cls ,