2009/5/29 Grzegorz Jaśkiewicz <gryz...@gmail.com>: > 2009/5/29 Adam Ruth <adamr...@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 >> >
Version 8.4 has an internal function unnest(anyarray): http://developer.postgresql.org/pgdocs/postgres/functions-array.html Osvaldo -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
