Re: Concatenate performance question

"Michael Guyver" <kenevel(at)googlemail(dot)com> writes:
> ... Running the array_append version is faster by at least one order of
> magnitude in these examples.

Really? I see only about a 50% advantage (155 msec vs 105 msec) in both
8.1 and 8.2. What PG version are you running? What database encoding
are you using?

To a zeroth-order approximation, the two methods should have about the
same amount of data copying involved, and so the concatenation method
ought to win out based on avoiding array data structure manipulation
overhead (not to mention avoiding the array_to_string step, which makes
an extra pass over all the data). So I find my own results surprising,
and yours very much more so ...

regards, tom lane