CCing to list to maintain context.
On Sat, Feb 27, 2016 at 12:14 PM, Eric Mortensen wrote:
> Thanks Francisco, I had not considered MVCC. If that is true, it would seem
> to me that a GIN index would "always" be less efficient, as it potentially
> would have to update every key's posting tree if
Eric:
On Sat, Feb 27, 2016 at 11:46 AM, Eric Mortensen wrote:
> 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.
Also, bear in mind when a column is updated the tuple is too, and
MVCC treats it s