On Tue, Oct 6, 2015 at 11:08 PM, ajaykbs <ajayakumarbs(at)gmail(dot)com> 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)