Artacus <artacus@xxxxxxxxxxx> writes: >> 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? > Yeah, like you I was pretty worried about how it would handle using > larger arrays. But I was surprised to find that it did a super job of > handling even large arrays. Note that this depends quite a lot on what datatype the array elements are. Fixed-width types like int or float should be fast. Variable-width types like text or numeric, not so much. regards, tom lane
