Re: Numeric type - Mailing list pgsql-general

From Tom Lane
Subject Re: Numeric type
Date
Msg-id 2161.1066657092@sss.pgh.pa.us
Whole thread Raw
In response to Numeric type  (Nagib Abi Fadel <nagib_postgres@yahoo.com>)
List pgsql-general
Nagib Abi Fadel <nagib_postgres@yahoo.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

pgsql-general by date:

Previous
From: "Arjen van der Meijden"
Date:
Subject: Re: Recomended FS
Next
From: "Daniel E. Fisher"
Date:
Subject: Pgsql 7.3.3 on redhat 7.2 machin