Postgres Pro
Downloads
Home   >   mailing lists

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

From Alexander Kuzmenkov
Subject Re: [GENERAL] Index-only scan on GIN index for COUNT() queries
Date
Msg-id 07312ed6-dbfd-1d2e-7a96-236eef86b865@postgrespro.ru
Whole thread Raw
In response to [GENERAL] Index-only scan on GIN index for COUNT() queries  (Seamus Abshere <seamus@abshere.net>)
List pgsql-general
Tree view 
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 development progress in this thread:

https://www.postgresql.org/message-id/flat/ca192322-29fd-9e60-3766-fe5e69d1f9af%40postgrespro.ru#ca192322-29fd-9e60-3766-fe5e69d1f9af@postgrespro.ru

--
Alexander Kuzmenkov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company

pgsql-general by date:

Previous
From: Paul Lavoie
Date:
Subject: [GENERAL] CREATE FOREIGN TABLE difficulties
Next
From: Jim Fulton
Date:
Subject: [GENERAL] Trigger problems/questions