Re: [GENERAL] abusing plpgsql array variables

2008-09-11 Thread Tom Lane
Artacus <[EMAIL PROTECTED]> 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 di

Re: [GENERAL] abusing plpgsql array variables

2008-09-10 Thread Artacus
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? Yeah, like you I was pretty worried about how

Re: [GENERAL] abusing plpgsql array variables

2008-09-10 Thread Merlin Moncure
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?

[GENERAL] abusing plpgsql array variables

2008-09-10 Thread Ben
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? -- Sent via pgsql-general mailing list (pgsql-ge