Re: ToDo list update for BRIN indexes

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: ToDo list update for BRIN indexes
Date: 2015-12-21 12:54:43
Message-ID: CA+TgmoYnNFYRFVuvF4EFLohodJKfN7JZg_f1y0bLHAwr7E-tsg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Jul 9, 2015 at 4:49 PM, Jeff Janes <jeff(dot)janes(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2015-12-21 12:58:18 Re: Patch to improve a few appendStringInfo* calls
Previous Message Viktor Leis 2015-12-21 12:53:27 Re: Experimental evaluation of PostgreSQL's query optimizer