Re: ToDo list update for BRIN indexes

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: ToDo list update for BRIN indexes
Дата
Msg-id CA+TgmoYnNFYRFVuvF4EFLohodJKfN7JZg_f1y0bLHAwr7E-tsg@mail.gmail.com
обсуждение исходный текст
Ответ на ToDo list update for BRIN indexes  (Jeff Janes <jeff.janes@gmail.com>)
Ответы Re: ToDo list update for BRIN indexes  (Simon Riggs <simon@2ndQuadrant.com>)
Re: ToDo list update for BRIN indexes  (Bruce Momjian <bruce@momjian.us>)
Список 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 по дате отправления:

Предыдущее
От: Etsuro Fujita
Дата:
Сообщение: Re: Optimization for updating foreign tables in Postgres FDW
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Patch to improve a few appendStringInfo* calls