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 [email protected]
Whole thread Raw
In response to [GENERAL] Index-only scan on GIN index for COUNT() queries  (Seamus Abshere <[email protected]>)
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#[email protected]

--
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