Re: BRIN range operator class

Andreas Karlsson <andreas@proxel.se>

From: Andreas Karlsson <andreas@proxel.se>
To: Alvaro Herrera <alvherre@2ndquadrant.com>, Stefan Keller <sfkeller@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>, emre@hasegeli.com, Paul Ramsey <pramsey@cleverelephant.ca>, "Obe, Regina" <robe.dnd@cityofboston.gov>
Date: 2015-05-05T09:33:28Z
Lists: pgsql-hackers
On 05/05/2015 04:24 AM, Alvaro Herrera wrote:
> Stefan Keller wrote:
>> I'm keen to see if a PostGIS specialist jumps in and adds PostGIS
>> geometry support.
>
> Did you test the patch proposed here already?  It could be a very good
> contribution.

Indeed, I have done some testing of the patch but more people testing 
would be nice.

Andreas


Commits

  1. Refactor per-page logic common to all redo routines to a new function.

  2. Reduce use of heavyweight locking inside hash AM.

  3. Scan the buffer pool just once, not once per fork, during relation drop.

  4. Major patch from Thomas Lockhart <Thomas.G.Lockhart@jpl.nasa.gov>