Hello,
In addition to what has already been suggested
1. Use
VACUUM FREEZE ANALYZE;
Otherwise you will still have some trickle of write-activity going on,
not always efficiently, despite being in read-only mode. It's because
of what's referred to as Hint Bits:
http://wiki.postgresql.org/wiki/Hint_Bits
2. Low value for maintenance_work_mem
Ref:http://postgresql.nabble.com/How-to-configure-a-read-only-database-server-td4311924.html
regards
Sameer
--
View this message in context: http://postgresql.nabble.com/Optimizing-a-read-only-database-tp5849746p5850109.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.