Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 4D3B763253F for ; Sat, 10 Apr 2010 01:02:51 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 91840-09 for ; Sat, 10 Apr 2010 04:02:41 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.17.8]) by mail.postgresql.org (Postfix) with ESMTP id A1685632349 for ; Sat, 10 Apr 2010 01:02:40 -0300 (ADT) Received: from [192.168.0.105] (pool-96-244-14-10.bltmmd.fios.verizon.net [96.244.14.10]) by mrelayeu.kundenserver.de (node=mreu0) with ESMTP (Nemesis) id 0MIAsE-1Nwb581rHa-003SBD; Sat, 10 Apr 2010 06:02:37 +0200 Message-ID: <4BBFF85B.60107@2ndquadrant.com> Date: Sat, 10 Apr 2010 00:02:35 -0400 From: Greg Smith User-Agent: Thunderbird 2.0.0.24 (X11/20100317) MIME-Version: 1.0 To: =?GB2312?B?UkS7xtPAzsA=?= CC: pgsql-performance@postgresql.org Subject: Re: About =?GB2312?B?obBjb250ZXh0LXN3aXRjaGluZyBpc3N1ZQ==?= =?GB2312?B?IG9uIFhlb26hsSB0ZXN0IGNhc2Ugo78g?= References: In-Reply-To: Content-Type: text/plain; charset=GB2312 Content-Transfer-Encoding: 8bit X-Provags-ID: V01U2FsdGVkX1/mG72rJytOHmmftQT2rfS3zHcaOxGKOQbCOvI 7uiL6FxJM7QqNwrEy9ROi054vY513FCeH9SPnMZzeE4VYjE9In ldR/aQR/Xbv+7Xq36SRnUUnswI96CaA X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=-10 required=5 tests=none X-Spam-Level: X-Archive-Number: 201004/130 X-Sequence-Number: 38380 RD»ÆÓÀÎÀ wrote: > > Anybody have the test case of ¡° context-switching issue on Xeon¡± from > Tm lane £¿ > That takes me back: http://archives.postgresql.org/pgsql-performance/2004-04/msg00280.php That's a problem seen on 2004 era Xeon processors, and with PostgreSQL 7.4. I doubt it has much relevance nowadays, given a) that whole area of the code was rewritten for PostgreSQL 8.1, and b) today's Xeons are nothing like 2004's Xeons. -- Greg Smith 2ndQuadrant US Baltimore, MD PostgreSQL Training, Services and Support greg@2ndQuadrant.com www.2ndQuadrant.us