> 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!
In response to
pgsql-performance by date
|Next:||From: Jakub Ouhrabka||Date: 2008-01-03 17:51:43|
|Subject: Re: Linux/PostgreSQL scalability issue - problem with 8 cores|
|Previous:||From: Tom Lane||Date: 2008-01-03 16:59:30|
|Subject: Re: Linux/PostgreSQL scalability issue - problem with 8 cores |