Re: [HACKERS] regression bigtest needs very long time

> 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.
>

numeric/decimal is a new type for this release. I assume this extra
processing will be removed once we are sure it works.

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026