Re: Converting each item in array to a query result row

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: Adam Ruth <adamruth(at)mac(dot)com>
Cc: Postgres User <postgres(dot)developer(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Converting each item in array to a query result row
Date: 2009-05-29 12:08:23
Message-ID: 2f4958ff0905290508h13ae8f24xb29a5776e121ab1f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2009/5/29 Adam Ruth <adamruth(at)mac(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Geoffrey 2009-05-29 12:41:01 pg_usleep() location
Previous Message Adam Ruth 2009-05-29 12:00:31 Re: Converting each item in array to a query result row