Re: [HACKERS] regression bigtest needs very long time
От | SAKAIDA |
---|---|
Тема | Re: [HACKERS] regression bigtest needs very long time |
Дата | |
Msg-id | 377459E33AC.35E8SAKAIDA@smtp.psn.ne.jp обсуждение исходный текст |
Ответ на | Re: [HACKERS] regression bigtest needs very long time (Bruce Momjian <maillist@candle.pha.pa.us>) |
Ответы |
Re: [HACKERS] regression bigtest needs very long time
Re: [HACKERS] regression bigtest needs very long time |
Список | pgsql-hackers |
Bruce Momjian <maillist@candle.pha.pa.us> wrote: > > > SAKAIDA wrote: > > However, I think that there is no necessity of calculating the > > value of 1000 digits in the 'LOG' function. > > > > numeric/decimal is a new type for this release. I assume this extra > processing will be removed once we are sure it works. Thank you for your reply. At the next version, I hope that 'regression test/bigtest' ends in the short time. The patch as an example which I considered is the following. If this patch is applied, the processing which requires 1.5 hours in the current ends for 5 minutes. -- Regards. SAKAIDA Masaaki <sakaida@psn.co.jp> Osaka, Japan *** postgresql-6.5/src/test/regress/sql/numeric.sql.orig Fri Jun 11 02:49:31 1999 --- postgresql-6.5/src/test/regress/sql/numeric.sql Wed Jun 16 13:46:41 1999 *************** *** 626,632 **** -- * POWER(10, LN(value)) check -- ****************************** DELETE FROM num_result; ! INSERT INTO num_result SELECT id, 0, POWER('10'::numeric, LN(ABS(round(val,300)))) FROM num_data WHERE val != '0.0';SELECT t1.id1, t1.result, t2.expected --- 626,632 ---- -- * POWER(10, LN(value)) check -- ****************************** DELETE FROM num_result; ! INSERT INTO num_result SELECT id, 0, POWER('10'::numeric, LN(ABS(round(val,30)))) FROM num_data WHERE val != '0.0';SELECT t1.id1, t1.result, t2.expected *** postgresql-6.5/src/test/regress/sql/numeric_big.sql.orig Thu Jun 17 19:22:53 1999 --- postgresql-6.5/src/test/regress/sql/numeric_big.sql Thu Jun 17 19:27:36 1999 *************** *** 602,608 **** -- * Natural logarithm check -- ****************************** DELETE FROM num_result; ! INSERT INTO num_result SELECT id, 0, LN(ABS(val)) FROM num_data WHERE val != '0.0'; SELECT t1.id1, t1.result, t2.expected --- 602,608 ---- -- * Natural logarithm check -- ****************************** DELETE FROM num_result; ! INSERT INTO num_result SELECT id, 0, LN(round(ABS(val),30)) FROM num_data WHERE val != '0.0'; SELECT t1.id1, t1.result,t2.expected *************** *** 614,620 **** -- * Logarithm base 10 check -- ****************************** DELETE FROM num_result; ! INSERT INTO num_result SELECT id, 0, LOG('10'::numeric, ABS(val)) FROM num_data WHERE val != '0.0'; SELECT t1.id1,t1.result, t2.expected --- 614,620 ---- -- * Logarithm base 10 check -- ****************************** DELETE FROM num_result; ! INSERT INTO num_result SELECT id, 0, LOG('10'::numeric, round(ABS(val),30)) FROM num_data WHERE val != '0.0'; SELECTt1.id1, t1.result, t2.expected *************** *** 626,632 **** -- * POWER(10, LN(value)) check -- ****************************** DELETE FROM num_result; ! INSERT INTO num_result SELECT id, 0, POWER('10'::numeric, LN(ABS(round(val,1000)))) FROM num_data WHERE val !='0.0'; SELECT t1.id1, t1.result, t2.expected --- 626,632 ---- -- * POWER(10, LN(value)) check -- ****************************** DELETE FROM num_result; ! INSERT INTO num_result SELECT id, 0, POWER('10'::numeric, LN(ABS(round(val,30)))) FROM num_data WHERE val != '0.0';SELECT t1.id1, t1.result, t2.expected
В списке pgsql-hackers по дате отправления: