Re: [GENERAL] Performance implications of numeric?

2012-08-23 Thread Merlin Moncure
On Tue, Aug 21, 2012 at 11:27 PM, Wells Oliver wellsoli...@gmail.com wrote: 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

Re: [GENERAL] Performance implications of numeric?

2012-08-22 Thread Craig Ringer
On 08/23/2012 12:48 AM, Wells Oliver wrote: Hey, thanks for your feedback. Just to clarify: pg_total_relation_size returns bytes, correct? Please reply to the list, not directly to me. Yes, pg_total_relation_size returns bytes. The documentation

[GENERAL] Performance implications of numeric?

2012-08-21 Thread Wells Oliver
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

Re: [GENERAL] Performance implications of numeric?

2012-08-21 Thread Craig Ringer
On 08/22/2012 12:27 PM, Wells Oliver wrote: 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