Just checked: the execution time is the same when I drop the index.
Execution plan with index:
---
"Bitmap Heap Scan on articles (cost=16.25..135.64 rows=33 width=427)"
" Recheck Cond: (data @> '{"locked": true}'::jsonb)"
" -> Bitmap Index Scan on idx_data (cost=0.00..16.24 rows=33 width=0)"
Hi all,
The pg version in question is the latest 9.4., running on Windows.
For testing out the NoSQL features of pg I have a simple table called
‘articles’ with a column called ‘data’.
There is an index on ‘data’ like this:
CREATE INDEX idx_data ON articles USING gin (data jsonb_path_ops);
T
