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

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Matthew Wakeling <matthew(at)flymine(dot)org>
Cc: Merlin Moncure <mmoncure(at)gmail(dot)com>, Eliot Gable <egable+pgsql-performance(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL Function Language Performance: C vs PL/PGSQL
Date: 2010-06-01 12:54:53
Message-ID: 20100601125453.GU21875@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

* Matthew Wakeling (matthew(at)flymine(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Matthew Wakeling 2010-06-01 12:59:35 Re: PostgreSQL Function Language Performance: C vs PL/PGSQL
Previous Message Matthew Wakeling 2010-06-01 12:47:08 Re: PostgreSQL Function Language Performance: C vs PL/PGSQL