Jon Lapham <lapham(at)jandr(dot)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