On Tue, Jun 2, 2009 at 2:27 PM, Merlin Moncure <mmoncure@xxxxxxxxx> wrote: > _IF_ arrays fit your requirements, they are an extremely compact and > efficient way to store your data. The requirements are exact..you > can't update or extract a single piece of data out of a block > efficiently. While indexing techniques are possible with gist, they > are moderate help at best. But if arrays fit, your table will be a > fraction of size of the 'row per datum' approach, at the cost of > flexibility. arrays are an enormous footgun when used in tables, but > if used properly can work well. Gin index works with arrays too. -- GJ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
