Re: Numeric type

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Nagib Abi Fadel <nagib_postgres(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Numeric type
Date: 2003-10-20 13:38:12
Message-ID: 2161.1066657092@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Nagib Abi Fadel <nagib_postgres(at)yahoo(dot)com> writes:
> does specifiying the precision and the scale of a
> numeric type increases the speed of calculations on a
> column of that type ???

No. It makes no difference when reading the column, and adds a small
overhead (for enforcing the restriction) when writing it.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Daniel E. Fisher 2003-10-20 13:53:31 Pgsql 7.3.3 on redhat 7.2 machin
Previous Message Arjen van der Meijden 2003-10-20 13:35:25 Re: Recomended FS