Re: upgrade from 9.2.x to 9.3 causes significant performance degradation

From: Kevin Grittner <kgrittn(at)ymail(dot)com>
To: Lonni J Friedman <netllama(at)gmail(dot)com>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Cc: Eduardo Morras <emorrasg(at)yahoo(dot)es>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: upgrade from 9.2.x to 9.3 causes significant performance degradation
Date: 2013-09-18 09:02:59
Message-ID: 1379494979.65262.YahooMailNeo@web162904.mail.bf1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Lonni J Friedman <netllama(at)gmail(dot)com> wrote:

> top shows over 90% of the load is in sys space.  vmstat output
> seems to suggest that its CPU bound (or bouncing back & forth):

Can you run `perf top` during an episode and see what kernel
functions are using all that CPU?

This looks similar to cases I've seen of THP defrag going wild.
Did the OS version or configuration change?  Did the PostgreSQL
memory settings (like shared_buffers) change?

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Grittner 2013-09-18 09:25:13 Re: Cannot commit when autoCommit is enabled error
Previous Message Albe Laurenz 2013-09-18 07:41:40 Re: Cannot commit when autoCommit is enabled error