There's been far more ideas and testing done around improving shared
buffer management than I can remember, and I suspect I'm not alone in
that regard. So I've created a wiki page as a place to pull this
information together. I'll try and keep highlights/important links
posted there, but help would be welcome. I think that in particular any
test data would be very useful to post there.
https://wiki.postgresql.org/wiki/Shared_Buffer_Improvements
--
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com