On Tue, Jun 2, 2009 at 2:27 PM, Merlin Moncure <mmoncure@gmail.com> 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