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

From: Alexander Kuzmenkov <a(dot)kuzmenkov(at)postgrespro(dot)ru>
To: Seamus Abshere <seamus(at)abshere(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: Index-only scan on GIN index for COUNT() queries
Date: 2017-06-15 17:09:37
Message-ID: 07312ed6-dbfd-1d2e-7a96-236eef86b865@postgrespro.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)ru#ca192322-29fd-9e60-3766-fe5e69d1f9af(at)postgrespro(dot)ru

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jim Fulton 2017-06-15 17:23:28 Trigger problems/questions
Previous Message Paul Lavoie 2017-06-15 16:49:28 CREATE FOREIGN TABLE difficulties