Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group