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.