Re: pg 8.1.3, AIX, huge box, painfully slow.

From: "Luke Lonergan" <llonergan(at)greenplum(dot)com>
To: "Gavin Hamill" <gdh(at)laterooms(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: pg 8.1.3, AIX, huge box, painfully slow.
Date: 2006-04-07 22:56:52
Message-ID: C05C3C44.211A5%llonergan@greenplum.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Gavin,

On 4/7/06 3:27 PM, "Gavin Hamill" <gdh(at)laterooms(dot)com> wrote:

> 278774: __semop(15728650, 0x0FFFFFFFFFFF7E80, 1) = 0
> 155712: __semop(15728650, 0x0FFFFFFFFFFF5920, 1) = 0
> 278774: __semop(15728649, 0x0FFFFFFFFFFF6F10, 1)
> 114914: __semop(15728649, 0x0FFFFFFFFFFF6A40, 1) = 0 = 0
> 114914: __semop(15728650, 0x0FFFFFFFFFFF61E0, 1)
> 155712: __semop(15728650, 0x0FFFFFFFFFFF6850, 1) = 0 = 0
> 155712: __semop(15728650, 0x0FFFFFFFFFFF6890, 1) = 0 1
> 55712: __semop(15728650, 0x0FFFFFFFFFFF5920, 1)
> 278774: __semop(15728650, 0x0FFFFFFFFFFF6F10, 1)
> 155712: __semop(15728650, 0x0FFFFFFFFFFF6850, 1) = 0 = 0
> 278774: __semop(15728649, 0x0FFFFFFFFFFF7E40, 1)
> 114914: __semop(15728649, 0x0FFFFFFFFFFF6A80, 1) = 0 = 0
> 278774: __semop(15728650, 0x0FFFFFFFFFFF7E80, 1)

Seems like you're hitting a very small target in RAM with these semop calls.
I wonder what part of the code is doing this - Tom would know better how to
trace it, but the equivalent of oprofile output would be nice.

The other thing that I'd like to see is an evaluation of the memory access
latency of this machine from Register to RAM. I couldn't find a
benchmarking tool that was UNIX friendly out there, maybe I'll write one
real quick. I suspect this machine has a heinous latency and a storm of
semops to the same spot of RAM might be a far worse performance problem on
this machine than on others...

- Luke

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2006-04-07 23:05:38 Re: pg 8.1.3, AIX, huge box, painfully slow.
Previous Message Tom Lane 2006-04-07 22:52:20 Re: pg 8.1.3, AIX, huge box, painfully slow.