[sgarland]

The advantage is when you want to store something for ease of use, but don’t want the disk (and memory, since pages read are loaded into the buffer pool) hit. So here, you could precompute the vector and index it, while not taking the double hit on size.

[brightball]

That’s the same benefit in Postgres as creating an index with the result of function.