Postgres Pro
Downloads
Home   >   mailing lists

Re: high-dimensional knn-GIST tests (was Re: Cube extension kNN support) - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: high-dimensional knn-GIST tests (was Re: Cube extension kNN support)
Date
Msg-id 20131024040529.GB6832@eldon.alvh.no-ip.org
Whole thread Raw
In response to high-dimensional knn-GIST tests (was Re: Cube extension kNN support)  (Gordon Mohr <gojomo-pgsql@xavvy.com>)
Responses Re: high-dimensional knn-GIST tests (was Re: Cube extension kNN support)  (Gordon Mohr <gojomo-pgsql@xavvy.com>)
Re: high-dimensional knn-GIST tests (was Re: Cube extension kNN support)  (Gordon Mohr <gojomo@xavvy.com>)
List pgsql-hackers
Tree view 
Gordon Mohr wrote:

> Thanks for this! I decided to give the patch a try at the bleeding
> edge with some high-dimensional vectors, specifically the 1.4
> million 1000-dimensional Freebase entity vectors from the Google
> 'word2vec' project:
> 
> https://code.google.com/p/word2vec/#Pre-trained_entity_vectors_with_Freebase_naming
> 
> Unfortunately, here's what I found:

I wonder if these results would improve with this patch:
http://www.postgresql.org/message-id/EFEDC2BF-AB35-4E2C-911F-FC88DA6473D7@gmail.com

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

pgsql-hackers by date:

Previous
From: Sameer Kumar
Date:
Subject: Re: Re: Using indexes for ORDER BY and PARTITION BY clause in windowing functions
Next
From: Craig Ringer
Date:
Subject: How should RLS treat ON DELETE CASCADE, ON UPDATE CASCADE, and ON DELETE SET NULL?