Jon Lapham <lapham@xxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster