Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] regression bigtest needs very long time

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: SAKAIDA <sakaida(at)psn(dot)co(dot)jp>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] regression bigtest needs very long time
Date: 1999-06-24 15:47:57
Message-ID: 199906241547.LAA17115@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
> 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

In response to

Responses

pgsql-hackers by date

Next:From: Thomas LockhartDate: 1999-06-24 16:04:11
Subject: Re: [HACKERS] Re: [PORTS] Postgres on NT freezing
Previous:From: Bruce MomjianDate: 1999-06-24 15:46:27
Subject: Re: [PORTS] Postgres on NT freezing

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group