Horton

Re: BRIN range operator class

Emre Hasegeli <emre@hasegeli.com>

View thread View on postgr.es
From: Emre Hasegeli <emre@hasegeli.com>
To: Andreas Karlsson <andreas@proxel.se>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>, Stefan Keller <sfkeller@gmail.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>, Paul Ramsey <pramsey@cleverelephant.ca>, "Obe, Regina" <robe.dnd@cityofboston.gov>
Date: 2015-05-05T10:06:37Z
Lists: pgsql-hackers 
> Indeed, I have done some testing of the patch but more people testing would
> be nice.

The inclusion opclass should work for other data types as long
required operators and SQL level support functions are supplied.
Maybe it would work for PostGIS, too.

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>