Re: newbie table design question

On Tue, Jun 2, 2009 at 2:27 PM, Merlin Moncure <mmoncure(at)gmail(dot)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