By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,660 Members | 1,230 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,660 IT Pros & Developers. It's quick & easy.

Numeric type

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.