Re: Wierd context-switching issue on Xeon

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pg(at)fastcrypt(dot)com
Cc: lutzeb(at)aeccom(dot)com, Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-performance(at)postgreSQL(dot)org, Neil Conway <neilc(at)samurai(dot)com>
Subject: Re: Wierd context-switching issue on Xeon
Date: 2004-04-19 02:20:22
Message-ID: 13960.1082341222@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Dave Cramer <pg(at)fastcrypt(dot)com> writes:
> So the the kernel/OS is irrelevant here ? this happens on any dual xeon?

I believe so. The context-switch behavior might possibly be a little
more pleasant on other kernels, but the underlying spinlock problem is
not dependent on the kernel.

> What about hypterthreading does it still happen if HTT is turned off ?

The problem comes from keeping the caches synchronized between multiple
physical CPUs. AFAICS enabling HTT wouldn't make it worse, because a
hyperthreaded processor still only has one cache.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2004-04-19 02:30:08 Re: Wierd context-switching issue on Xeon
Previous Message Tom Lane 2004-04-19 02:16:53 Re: sunquery and estimated rows