Re: PostgreSQL Function Language Performance: C vs PL/PGSQL

* Matthew Wakeling (matthew@flymine.org) wrote:
> The major case I found when writing pl/pgsql was when trying to build
> arrays row by row. AFAIK when I tried it, adding a row to an array caused
> the whole array to be copied, which put a bit of a damper on performance.

Using the built-ins now available in 8.4 (array_agg), that copying
doesn't happen any more.

    Thanks,

        Stephen