2014-03-14 4:26 GMT+09:00 <fburgess@xxxxxxxxxxxxxxx>: > PostgreSQL 9.3.3 RHEL 6.4 > > Total db Server memory 64GB (...) > effective_cache_size = 48MB I'm not sure if this will help directly, but is the value for 'effective_cache_size' intentional? 48 *GB* would be a more likely setting. Regards Ian Barwick -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance