2014-03-14 4:26 GMT+09:00 <fburg...@radiantblue.com>: > 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-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general