On Wed, Sep 10, 2008 at 4:03 PM, Ben <bench@silentmedia.com> wrote:
> If I want to pass in a text[] argument to a plpgsql function, at what array
> size am I asking for problems? 100? 10,000? 100,000?
>
> What severity of problems might I encounter? Bad performance? Postgres
> refusing to run my query? A crashed backend?
see for yourself:
postgres=# select length(array_to_string(array(select
generate_series(1,100000)), '|'));
length
--------
588894
(1 row)
Time: 107.283 ms
(array options can get inefficient if large, but it's mainly cpu bound stuff).
merlin