471,354 Members | 2,099 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,354 software developers and data experts.

Numeric type

Hi,

does specifiying the precision and the scale of a
numeric type increases the speed of calculations on a
column of that type ???
(I read the docs : nothing mentioed about that.)
Thx


__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 12 '05 #1
1 1683
Nagib Abi Fadel <na************@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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by M.A. Oude Kotte | last post: by
2 posts views Thread by jobs | last post: by
reply views Thread by XIAOLAOHU | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.