> 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@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026