On 15.06.2017 17:43, Seamus Abshere wrote:
Theoretically, could support be added for Index-only scans on GIN
indexes when only a COUNT() is requested?
Hi Seamus,
I am working on a patch that adds this possibility for GIN and any other
indexes that support bitmap scans.
You can follow the deve
hi,
We have a GIN index on jsonb_col. We always get Bitmap Index Scan +
Bitmap Heap Scan when we do things like
SELECT COUNT(*) FROM mytable WHERE jsonb_col ? 'key1'
Theoretically, could support be added for Index-only scans on GIN
indexes when only a COUNT() is requested?
Thanks,
Seamus
PS. H