General Postgres performance tips when using ARRAY

From: bubba postgres <bubba(dot)postgres(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: General Postgres performance tips when using ARRAY
Date: 2011-05-26 01:17:26
Message-ID: BANLkTinfjquDe6mRTyrBSjR-tX-1R4_Egg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andy Lurie 2011-05-26 02:15:57 OHI to Sponsor PG West 2011
Previous Message Tommy 2011-05-25 22:48:17 Re: Access to postgres conversion