Re: Proposal: partition pruning by secondary attributes - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Proposal: partition pruning by secondary attributes
Date
Msg-id 20180208174834.btjh267gph5inwyc@alvherre.pgsql
Whole thread Raw
In response to Proposal: partition pruning by secondary attributes  (Ildar Musin <i.musin@postgrespro.ru>)
Responses Re: Proposal: partition pruning by secondary attributes  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
Ildar Musin wrote:

> The idea is to store min and max values of secondary attributes (like
> 'id' in the example above) for each partition somewhere in catalog and
> use it for partition pruning along with partitioning key. You can think
> of it as somewhat like BRIN index but for partitions.

What is the problem with having a BRIN index?

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: [HACKERS] A design for amcheck heapam verification
Next
From: Rafal Pietrak
Date:
Subject: Re: it's a feature, but it feels like a bug