On Wed, Sep 10, 2008 at 4:03 PM, Ben <bench@xxxxxxxxxxxxxxx> 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
