Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 5C1729FB2E8 for ; Sat, 31 Mar 2007 12:54:34 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 01529-05 for ; Sat, 31 Mar 2007 12:54:30 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from cse.ohio-state.edu (mail.cse.ohio-state.edu [164.107.123.5]) by postgresql.org (Postfix) with ESMTP id 34BC49FB2B4 for ; Sat, 31 Mar 2007 12:54:31 -0300 (ADT) Received: from [164.107.116.241] (jason.cse.ohio-state.edu [164.107.116.241]) (authenticated bits=0) by cse.ohio-state.edu (8.12.11.20060308/8.12.11) with ESMTP id l2VFsWoE022578 for ; Sat, 31 Mar 2007 11:54:32 -0400 (EDT) Message-ID: <460E8435.3000605@cse.ohio-state.edu> Date: Sat, 31 Mar 2007 11:54:29 -0400 From: Xiaoning Ding User-Agent: Thunderbird 1.5.0.10 (X11/20070301) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: scalablility problem References: <460D7220.9010302@cse.ohio-state.edu> <874po2tdlx.fsf@wolfe.cbbrowne.com> <54F3EA5A-EFB0-4537-9344-EA929BC9C4E8@event-s.net> <20070331114104.GD11402@mathom.us> In-Reply-To: <20070331114104.GD11402@mathom.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/468 X-Sequence-Number: 23873 Michael Stone wrote: > On Fri, Mar 30, 2007 at 10:00:30PM -0600, Guido Neitzer wrote: >> On 30.03.2007, at 19:18, Christopher Browne wrote: >>> 2. There are known issues with the combination of Xeon processors and >>> PAE memory addressing; that sort of hardware tends to be *way* less >>> speedy than the specs would suggest. >> >> That is not true as the current series of processors (Woodcrest and >> the like) are also called Xeon. You probably mean the Pentium IV era >> Xeons. > > Well, the newer ones can address large amounts of memory directly, > without using PAE, but the original comment was correct--PAE is slow > regardless of what processor implements it. Here is the information in /proc/cpuinfo processor : 6 vendor_id : GenuineIntel cpu family : 15 model : 4 model name : Intel(R) Xeon(TM) CPU 2.80GHz stepping : 8 cpu MHz : 2793.091 cache size : 2048 KB physical id : 0 siblings : 4 core id : 1 cpu cores : 2 fpu : yes fpu_exception : yes cpuid level : 5 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm pni monitor ds_cpl est cid cx16 xtpr bogomips : 5586.08 clflush size : 64 cache_alignment : 128 address sizes : 36 bits physical, 48 bits virtual > > Mike Stone > > ---------------------------(end of broadcast)--------------------------- > TIP 7: You can help support the PostgreSQL project by donating at > > http://www.postgresql.org/about/donate > >