Hi
When a jsonb column is updated, as far as I understand the entire column is
updated, even though perhaps only one of the keys has a modified value.
My question is: if I have a GIN index on that column, will PG visit every
key and update each index entry, or will it visit every key and update each
index entry only if the value is different, or will it only visit those
keys that have been modified?
I have a jsonb column where I only need to index two keys, and was
wondering if there is any benefit in terms of update efficiency to having
two indexes, one for each key, rather than just creating a GIN index on the
whole (rather large) column.
Thanks,
Eric