Re: Linux/PostgreSQL scalability issue - problem with 8 cores - Mailing list pgsql-performance

From Jakub Ouhrabka
Subject Re: Linux/PostgreSQL scalability issue - problem with 8 cores
Date
Msg-id 477D1D59.7050002@comgate.cz
Whole thread Raw
In response to Re: Linux/PostgreSQL scalability issue - problem with 8 cores  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Linux/PostgreSQL scalability issue - problem with 8 cores  (Jakub Ouhrabka <kuba@comgate.cz>)
List 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


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Linux/PostgreSQL scalability issue - problem with 8 cores
Next
From: Jakub Ouhrabka
Date:
Subject: Re: Linux/PostgreSQL scalability issue - problem with 8 cores