Re:Better JSON in Postgres with PostgreSQL 14
by zeroimpl on Tuesday June 01, 2021 @07:13PM
(#27362680)
Anybody know if there any performance/query plan differences between the following?
And
[ Parent
| on HN ]
> While I wouldn't recommend simply using the subscript format everywhere in your application due to it not always leveraging indexes...
I assumed that the subscript format was basically preprocessed into the arrow format, but this kind of implies that it's not. It's too bad the point isn't more clear here as I'm curious as well.