Re: Linux/PostgreSQL scalability issue - problem with 8 cores

From: Jakub Ouhrabka <kuba(at)comgate(dot)cz>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Linux/PostgreSQL scalability issue - problem with 8 cores
Date: 2008-01-03 17:37:29
Message-ID: 477D1D59.7050002@comgate.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi Tom,

> Interesting. Maybe you could use oprofile to try to see what's
> happening? It sounds a bit like momentary contention for a spinlock,
> but exactly what isn't clear.

ok, we're going to try oprofile, will let you know...

> Perhaps. Have you tried logging executions of NOTIFY to see if they
> are correlated with the spikes?

We didn't log the notifies but I think it's not correlated. We'll have a
detailed look next time we try it (with oprofile).

Thanks for suggestions!

Kuba

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jakub Ouhrabka 2008-01-03 17:51:43 Re: Linux/PostgreSQL scalability issue - problem with 8 cores
Previous Message Tom Lane 2008-01-03 16:59:30 Re: Linux/PostgreSQL scalability issue - problem with 8 cores