Re: zLinux Load Testing Experience

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Cc: Andrew Hastie <andrew(at)ahastie(dot)net>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: zLinux Load Testing Experience
Date: 2013-04-30 19:46:10
Message-ID: CAHyXU0zVUCpQgnJJvVQtEbE1_DnaBrU5DrjuTCyU=g2QHR3eDg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Apr 30, 2013 at 12:26 PM, Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:
> On Tue, Apr 30, 2013 at 8:28 AM, Andrew Hastie <andrew(at)ahastie(dot)net> wrote:
>>
>> I'm currently working on a project porting an application from RedHat
>> Linux on Intel onto IBM zLinux. Our application requires PostgreSQL at
>> version 9.n, so the PostgreSQL binaries have been built using the standard
>> build tools from source. Everything appears run correctly. However as part
>> of performance testing, our IBM and Linux SysProgs have been "poking around"
>> using strace and have reported the following (which they think is an error
>> condition) when hooking up to the postmaster processes:-
>>
>> read(3, 0x3ffff875ee0, 16) = -1 EAGAIN (Resource temporarily unavailable)
>> poll([{fd=3, events=POLLIN}, {fd=6, events=POLLIN}], 2, 200) = 0 (Timeout)
>> read(3, 0x3ffff875ee0, 16) = -1 EAGAIN (Resource temporarily unavailable)
>> poll([{fd=3, events=POLLIN}, {fd=6, events=POLLIN}], 2, 10000) = 0
>> (Timeout)
>> ... repeated many times
>>
>
>
> That does not look like the postmaster process. It looks like probably the
> background writer process.
>
> It is normal, and doesn't explain high CPU utilization.

yeah: we're probably a couple of steps in front of deep system
profiling. Helpful things to provide to help diagnose would be:

*) 'explain analyze' of the queries that are eating cpu
*) more details about the hardware -- how many cpu, etc.
*) better definition of 'perceived high CPU utilisation'
*) some correlating performance tests, expecially cpu bound pgbench
tests (pgbench -S)

merlin

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Carlo Stonebanks 2013-04-30 23:00:31 Re: Simple SQL INSERT to avoid duplication failed: why?
Previous Message Ben Chobot 2013-04-30 17:38:01 Re: Basic question on recovery and disk snapshotting