Artacus <artacus@comcast.net> 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