Performance implications of numeric?

[Wells Oliver <wellsoliver@xxxxxxxxx>]

We have a lot of tables which store numeric data. These tables all use the numeric type, where the values are 95% integer values. We used numeric because it eliminated the need for casting during division to yield a floating point value.

I'm curious as to whether this would have performance and/or disk size implications. Would converting these columns to integer (or double precision on the handful that require the precision) and forcing developers to use explicit casting be worth the time?

Thanks for any clarification.

--
Wells Oliver
wellsoliver@xxxxxxxxx