Re: [GENERAL] How jsonb updates affect GIN indexes

2016-02-27 Thread Francisco Olarte
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

Re: [GENERAL] How jsonb updates affect GIN indexes

2016-02-27 Thread Francisco Olarte
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