Re: [HACKERS] WIP: BRIN multi-range indexes

2017-10-30 Thread Tomas Vondra
Hi, attached is a patch series that includes both the BRIN multi-range minmax indexes discussed in this thread, and the BRIN bloom indexes initially posted in [1]. It seems easier to just deal with a single patch series, although we may end up adding just one of those proposed opclasses. There

Re: [HACKERS] WIP: BRIN multi-range indexes

2017-10-25 Thread Tomas Vondra
Apparently I've managed to botch the git format-patch thing :-( Attached are both patches (the first one adding BRIN bloom indexes, the other one adding the BRIN multi-range). Hopefully I got it right this time ;-) regards -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL

[HACKERS] WIP: BRIN multi-range indexes

2017-10-25 Thread Tomas Vondra
Hi all, A couple of days ago I've shared a WIP patch [1] implementing BRIN indexes based on bloom filters. One inherent limitation of that approach is that it can only support equality conditions - that's perfectly fine in many cases (e.g. with UUIDs it's rare to use range queries, etc.). [1]