Grzegorz Jaśkiewicz wrote:
true, if you don't want to search on values too much ,or at all - use float[]. But otherwise, keep stuff in a tables as such. It might be humongous in size, but at the end of the day - prime thing when designing a db is speed of queries.
If he's worried about speed, he might look into porting contrib/intarray to arrays of floats. I've had good luck improving performance by converting big tables of ints into intarray with indexes. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
