Re: scalablility problem

От: Xiaoning Ding
Тема: Re: scalablility problem
Дата: ,
Msg-id: 460E8435.3000605@cse.ohio-state.edu
(см: обсуждение, исходный текст)
Ответ на: Re: scalablility problem  (Michael Stone)
Список: pgsql-performance

Скрыть дерево обсуждения

scalablility problem  (Xiaoning Ding <-state.edu>, )
 Re: scalablility problem  ("Dave Dutcher", )
 Re: scalablility problem  (Tom Lane, )
  Re: scalablility problem  (Xiaoning Ding <-state.edu>, )
   Re: scalablility problem  (Scott Marlowe, )
   Re: scalablility problem  (Ron Mayer, )
    Re: scalablility problem  (Xiaoning Ding <-state.edu>, )
     Re: scalablility problem  (Dave Cramer, )
 Re: scalablility problem  (Scott Marlowe, )
  Re: scalablility problem  (Xiaoning Ding <-state.edu>, )
   Re: scalablility problem  ("Joshua D. Drake", )
    Re: scalablility problem  (Tom Lane, )
     Re: scalablility problem  (Xiaoning Ding <-state.edu>, )
 Re: scalablility problem  (Christopher Browne, )
  Re: scalablility problem  (Guido Neitzer, )
   Re: scalablility problem  (Michael Stone, )
    Re: scalablility problem  (Xiaoning Ding <-state.edu>, )
  Re: scalablility problem  (Xiaoning Ding <-state.edu>, )

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
>
>



В списке pgsql-performance по дате сообщения:

От: Xiaoning Ding
Дата:
Сообщение: Re: scalablility problem
От: Andrew - Supernews
Дата:
Сообщение: Re: Scaling SELECT:s with the number of disks on a stripe