On 03/12/06, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
"Michael Guyver" <kenevel@xxxxxxxxxxxxxx> 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?
Hi Tom, Thanks for taking the time to have a look at this. Perhaps I overstated the case when I said an order of magnitude :¬O That said, however, I'm fairly sure that the difference was more than you've seen. The hardware may indeed have been a factor - I was running psql 8.1 on a laptop (AMD 64 3200, 1GB RAM, 5400rpm HDD) so the difference in performance may have been more pronounced. I will check the figures when I next get to my laptop at home, but I'm currently doing silly hours at work for the release we have this week.
