On Tue, 1 Jun 2010, Stephen Frost wrote:
* Matthew Wakeling (matthew@xxxxxxxxxxx) 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. I had wondered if that had been improved.
Matthew
--
Our riverbanks and seashores have a beauty all can share, provided
there's at least one boot, three treadless tyres, a half-eaten pork
pie, some oil drums, an old felt hat, a lorry-load of tar blocks,
and a broken bedstead there. -- Flanders and Swann
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
