Re: ToDo list update for BRIN indexes - Mailing list pgsql-hackers

From Robert Haas
Subject Re: ToDo list update for BRIN indexes
Date
Msg-id CA+TgmoYnNFYRFVuvF4EFLohodJKfN7JZg_f1y0bLHAwr7E-tsg@mail.gmail.com
Whole thread Raw
In response to ToDo list update for BRIN indexes  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: ToDo list update for BRIN indexes  (Simon Riggs <simon@2ndQuadrant.com>)
Re: ToDo list update for BRIN indexes  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
On Thu, Jul 9, 2015 at 4:49 PM, Jeff Janes <jeff.janes@gmail.com> wrote:
> Is there anything in the below section which has been been implemented or
> rendered irrelevant by BRIN indexes?
>
> https://wiki.postgresql.org/wiki/Todo#Indexes
>
> "Consider smaller indexes that record a range of values per heap page,
> rather than having one index entry for every heap row"

[ catching up on old threads ]

BRIN is exactly this, isn't it?  Well, moreso: it's a range of values
for a range of heap pages.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Etsuro Fujita
Date:
Subject: Re: Optimization for updating foreign tables in Postgres FDW
Next
From: Robert Haas
Date:
Subject: Re: Patch to improve a few appendStringInfo* calls