Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Lonni J Friedman <netllama@xxxxxxxxx> 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


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux