On Tue, Oct 6, 2015 at 11:08 PM, ajaykbs <ajayakumarbs@xxxxxxxxx> wrote: > I have checked the transparent huge pages and zone reclaim mode and those are > already disabled. > > As a trial and error method, I have reduced the shared buffer size from > 8500MB to 3000MB. > The CPU i/o wait is icreased a little. But the periodical over load has not > occurred afterwards. (3 days passed without such situation). I shall report > further developments. Reduce max connections to something more reasonable like < 100 and get a connection pooler in place (pgbouncer is simple to setup and use) -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
