Re: BRIN range operator class
Stefan Keller <sfkeller@gmail.com>
From: Stefan Keller <sfkeller@gmail.com>
To: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Cc: emre@hasegeli.com, Andreas Karlsson <andreas@proxel.se>,
Paul Ramsey <pramsey@cleverelephant.ca>, "Obe,
Regina" <robe.dnd@cityofboston.gov>
Date: 2015-05-05T01:40:11Z
Lists: pgsql-hackers
Hi, 2015-05-05 2:51 GMT+02:00 Andreas Karlsson <andreas@proxel.se>: > From my point of view as a reviewer this patch set is very close to being > committable. I'd like to thank already now to all committers and reviewers and hope BRIN makes it into PG 9.5. As a database instructor, conference organisator and geospatial specialist I'm looking forward for this clever new index. I'm keen to see if a PostGIS specialist jumps in and adds PostGIS geometry support. Yours, S. 2015-05-05 2:51 GMT+02:00 Andreas Karlsson <andreas@proxel.se>: > From my point of view as a reviewer this patch set is very close to being > committable. > > = brin-inclusion-v06-01-sql-level-support-functions.patch > > This patch looks good. > > = brin-inclusion-v06-02-strategy-numbers.patch > > This patch looks good, but shouldn't it be merged with 07? > > = brin-inclusion-v06-03-remove-assert-checking.patch > > As you wrote earlier this is needed because the new range indexes would > violate the asserts. I think it is fine to remove the assertion. > > = brin-inclusion-v06-04-fix-brin-deform-tuple.patch > > This patch looks good and can be committed separately. > > = brin-inclusion-v06-05-box-vs-point-operators.patch > > This patch looks good and can be committed separately. > > = brin-inclusion-v06-06-inclusion-opclasses.patch > > - "operator classes store the union of the values in the indexed column" is > not technically true. It stores something which covers all of the values. > - Missing space in "except box and point*/". > - Otherwise looks good. > > = brin-inclusion-v06-07-remove-minmax-amprocs.patch > > Shouldn't this be merged with 02? Otherwise it looks good. > > > -- > Andreas Karlsson > > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers
Commits
-
Refactor per-page logic common to all redo routines to a new function.
- f8f4227976a2 9.5.0 cited
-
Reduce use of heavyweight locking inside hash AM.
- 76837c1507cb 9.3.0 cited
-
Scan the buffer pool just once, not once per fork, during relation drop.
- ece01aae4792 9.2.0 cited
-
Major patch from Thomas Lockhart <Thomas.G.Lockhart@jpl.nasa.gov>
- 9e2a87b62db8 7.1.1 cited