Re: [HACKERS] regression bigtest needs very long time

Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)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(at)psn(dot)co(dot)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';
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,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