If you run your benchmarks for more than a few minutes I highly recommend enabling sysstat service data collection, then you can look at it after the fact with sar. VERY useful stuff both for benchmarking and post mortem on live servers. On Thu, Feb 14, 2013 at 9:32 PM, Dan Kogan <dan@xxxxxxxxxx> wrote: > Yes, we are seeing higher system % on the CPU, not sure how to quantify in terms of % right now - will check into that tomorrow. > We were not checking the context switch numbers during our benchmark, will check that tomorrow as well. > > -----Original Message----- > From: pgsql-performance-owner@xxxxxxxxxxxxxx [mailto:pgsql-performance-owner@xxxxxxxxxxxxxx] On Behalf Of Josh Berkus > Sent: Thursday, February 14, 2013 6:58 PM > To: pgsql-performance@xxxxxxxxxxxxxx > Subject: Re: High CPU usage / load average after upgrading to Ubuntu 12.04 > > On 02/14/2013 12:41 PM, Dan Kogan wrote: >> We used scale factor of 3600. >> Yeah, maybe other people see similar load average, we were not sure. >> However, we saw a clear difference right after the upgrade. >> We are trying to determine whether it makes sense for us to go to 11.04 or maybe there is something here we are missing. > > Well, I'm seeing a higher system % on CPU than I expect (around 15% on each core), and a MUCH higher context-switch than I expect (up to 500K). > Is that anything like you're seeing? > > -- > Josh Berkus > PostgreSQL Experts Inc. > http://pgexperts.com > > > -- > Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance > > -- > Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance -- To understand recursion, one must first understand recursion. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
