Re: scalablility problem

От: Xiaoning Ding
Тема: Re: scalablility problem
Дата: ,
Msg-id: 460FF128.8090403@cse.ohio-state.edu
(см: обсуждение, исходный текст)
Ответ на: Re: scalablility problem  (Ron Mayer)
Ответы: Re: scalablility problem  (Dave Cramer)
Список: 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>, )

I repeated the test again. It took 0.92 second under 8.2.3.
I checked system load using top and ps. There is no other
active processes.

Xiaoning

Ron Mayer wrote:
> Xiaoning Ding wrote:
>> Postgresql is 7.3.18. [...]
>> 1 process takes 0.65 second to finish.
>
>> I update PG to 8.2.3. The results are [...] now.
>> 1 process :    0.94 second
>
> You sure about your test environment?  Anything else
> running at the same time, perhaps?
>
> I'm a bit surprised that 8.2.3 would be 40% slower than 7.3.18
> even in the single process case.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
>



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

От: Xiaoning Ding
Дата:
Сообщение: Re: scalablility problem
От: Dave Cramer
Дата:
Сообщение: Re: scalablility problem