Re: [GENERAL] General Postgres performance tips when using ARRAY

2011-05-25 Thread Merlin Moncure
On Wed, May 25, 2011 at 9:17 PM, bubba postgres wrote: > > So, what are the gotcha's around manipulating Arrays in stored procs? > It seems reasonable that an array_cat /etc would cause the creation of a new > array, but does mutating an existing array also create a copy? Never, ever, if at all p

[GENERAL] General Postgres performance tips when using ARRAY

2011-05-25 Thread bubba postgres
So, what are the gotcha's around manipulating Arrays in stored procs? It seems reasonable that an array_cat /etc would cause the creation of a new array, but does mutating an existing array also create a copy?