subject:"\[GENERAL\] Index\-only scan on GIN index for COUNT\(\) queries"

Re: [GENERAL] Index-only scan on GIN index for COUNT() queries

2017-06-15 Thread Alexander Kuzmenkov

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

[GENERAL] Index-only scan on GIN index for COUNT() queries

2017-06-15 Thread Seamus Abshere

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.