On Tue, Oct 6, 2015 at 11:08 PM, ajaykbs <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
