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

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 dividing

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

FYI Postgresql 8.0.1 $ uname -a Linux example.example.com 2.4.21-27.0.2.ELsmp #1 SMP Wed Jan 19 01:53:23 GMT 2005 i686 i686 i386 GNU/Linux 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

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

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

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

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 happen