Re: [GENERAL] Strange plpgsql performance -- arithmetic, numeric()

2005-04-04 Thread Karl O. Pinc
On 04/03/2005 08:04:27 PM, Tom Lane wrote: "Karl O. Pinc" <[EMAIL PROTECTED]> writes: > Incrementing the loop counter by a factor of 10, from 1000 to 1 > makes the process take more than 100 times longer. (I only saw > this happen when I happened upon using a numeric() datatype > and then divi

Re: [GENERAL] Strange plpgsql performance -- arithmetic, numeric() type, arrays

2005-04-03 Thread Tom Lane
"Karl O. Pinc" <[EMAIL PROTECTED]> writes: > Incrementing the loop counter by a factor of 10, from 1000 to 1 > makes the process take more than 100 times longer. (I only saw > this happen when I happened upon using a numeric() datatype > and then dividing i/100 to avoid overflow. It does not

Re: [GENERAL] Strange plpgsql performance -- arithmetic, numeric()

2005-04-03 Thread Pavel Stehule
> Incrementing the loop counter by a factor of 10, from 1000 to 1 > makes the process take more than 100 times longer. (I only saw > this happen when I happened upon using a numeric() datatype > and then dividing i/100 to avoid overflow. It does not happen > without the array and working with