Re: [HACKERS] regression bigtest needs very long time

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