Re: Converting each item in array to a query result row - Mailing list pgsql-general

2009/5/29 Adam Ruth <adamruth@mac.com>:
> Always test your performance assumptions. The plpgsql function is faster
> than the sql function, a lot faster on smaller arrays.
>
> unnest - 10 element array - 100,000 times: 6701.746 ms
> unnest - 100 element array - 100,000 times: 11847.933 ms
> unnest - 1000 element array - 100,000 times: 59472.691 ms
>
> explode - 10 element array - 100,000 times: 1941.942 ms
> explode - 100 element array - 100,000 times: 8521.289 ms
> explode - 1000 element array - 100,000 times: 44980.048 ms
>

o.O




--
GJ