Postgres Pro
Downloads
Home   >   mailing lists

Re: High CPU usage / load average after upgrading to Ubuntu 12.04 - Mailing list pgsql-performance

From Josh Berkus
Subject Re: High CPU usage / load average after upgrading to Ubuntu 12.04
Date
Msg-id 5122C507.7060303@agliodbs.com
Whole thread Raw
In response to Re: High CPU usage / load average after upgrading to Ubuntu 12.04  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-performance
Tree view 
So, our drop in performance is now clearly due to pathological OS
behavior during checkpoints.  Still trying to pin down what's going on,
but it's not system load; it's clearly related to the IO system.

Anyone else see this?  I'm getting it both on 3.2 and 3.4.  We're using
LSI Megaraid.


--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

pgsql-performance by date:

Previous
From: John Lumby
Date:
Subject: Re: slow query plans caused by under-estimation of CTE cardinality
Next
From: Josh Berkus
Date:
Subject: Re: High CPU usage / load average after upgrading to Ubuntu 12.04