Postgres Pro
Downloads
Home   >   mailing lists

General Postgres performance tips when using ARRAY - Mailing list pgsql-general

From bubba postgres
Subject General Postgres performance tips when using ARRAY
Date
Msg-id BANLkTinfjquDe6mRTyrBSjR-tX-1R4_Egg@mail.gmail.com
Whole thread Raw
Responses Re: General Postgres performance tips when using ARRAY  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
Tree view

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?

pgsql-general by date:

Previous
From: Tommy
Date:
Subject: Re: Access to postgres conversion
Next
From: Merlin Moncure
Date:
Subject: Re: General Postgres performance tips when using ARRAY