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
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. |