On Wed, Sep 10, 2008 at 4:03 PM, Ben <[EMAIL PROTECTED]> 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general