Re: How much slower are numerics?

Jon Lapham <lapham@jandr.org> writes:
> Tom Lane wrote:
>> On modern hardware, I'd expect float operations to be at least an order
>> of magnitude faster than numerics

> But, this is less than a factor of 2 difference, similar to what one of
> the previous INSERT examples showed.  Or am I missing something?

You're not thinking about the overhead imposed by the plpgsql loop
construct.

            regards, tom lane