Re: PL/pgSQL Loop Vs. Batch Update

David Wheeler <david@kineticode.com> writes:
> Just on a lark, I tried to get this to work:

> try=# explain analyze EXECUTE foo(1, ARRAY
> [600001,600002,600003,600004,600005,600006,600007]);
>                                        QUERY PLAN
> ------------------------------------------------------------------------
> --------------
> Result  (cost=0.00..0.01 rows=1 width=0) (actual time=26.241..26.251
> rows=1 loops=1)
> Total runtime: 27.512 ms
> (2 rows)

> That's not much use.

It looks like you had something trivial as the definition of foo().
Try one of the actual queries from the plpgsql function.

            regards, tom lane