regression bigtest needs very long time

Поиск
Список
Период
Сортировка
От SAKAIDA
Тема regression bigtest needs very long time
Дата
Msg-id 377214D61B8.68B1SAKAIDA@smtp.psn.ne.jp
обсуждение исходный текст
Ответы Re: [HACKERS] regression bigtest needs very long time
Список pgsql-hackers
Hi,
  I always execute 'regression test' and 'regression bigtest'
when PostgreSQL was enhanced. However,'regression bigtest' needs
the very long processing time in PostgreSQL-6.5. In my computer, 
it is taken of about 1 hour.   
  The reason why the processing time is long is because 1000 
digits are calculated using the 'LOG' and 'POWER' function.  
  Actual statement in "postgresql-6.5/src/test/regress/sql/
numeric_big.sql" is the following.
  INSERT INTO num_result SELECT id, 0, POWER('10'::numeric,  LN(ABS(round(val,1000)))) FROM num_data WHERE val !=
'0.0';

  But, the processing ends for a few minutes when this 
"LN(ABS(round(val,1000)))" is made to be "LN(ABS(round(val,30)))".
  INSERT or SELECT must be tested using the value of 1000 digits,
because to handle NUMERIC and DECIMAL data type to 1000 digits is
possible.  
  However, I think that there is no necessity of calculating the 
value of 1000 digits in the 'LOG' function.  
  Comments?

--
Regards.

SAKAIDA Masaaki <sakaida@psn.co.jp>
Personal Software, Inc.   Osaka Japan



В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Sam O'Connor"
Дата:
Сообщение: Postgres on NT freezing
Следующее
От: Don Baccus
Дата:
Сообщение: Re: [HACKERS] The dangers of "-F"