January 10th, 2016 by depesz | Tags: , , , , , , , | Comments Off on Waiting for 9.6 – Cube extension kNN support

On 18th of December, Teodor Sigaev committed patch: Introduce distance operators over cubes: < #> taxicab distance < -> euclidean distance < => chebyshev distance Also add kNN support of those distances in GiST opclass. Author: Stas Kelvich

On 26th of March, Heikki Linnakangas committed patch: Add support for index-only scans in GiST. This adds a new GiST opclass method, 'fetch', which is used to reconstruct the original Datum from the value stored in the index. Also, the 'canreturn' index AM interface ...

Today, I'd like to show you how you can use the same index for two different types of conditions. One that is using normal BTree indexing ( equal, less than, greater than ), and one that is using GIN/GiST index, ...

On 3rd of November, Heikki Linnakangas committed patch: Support range data types. Selectivity estimation functions are missing for some range type operators, which is a TODO. Jeff Davis

On 4th of December, Tom Lane committed really cool patch: KNNGIST, otherwise known as order-by-operator support for GIST. This commit represents a rather heavily editorialized version of Teodor's builtin_knngist_itself-0.8.2 and builtin_knngist_proc-0.8.1 patches. I redid the opclass API to add a separate Distance method instead ...