Re: high-dimensional knn-GIST tests (was Re: Cube extension kNN support)

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Gordon Mohr <gojomo-pgsql(at)xavvy(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: high-dimensional knn-GIST tests (was Re: Cube extension kNN support)
Date: 2013-10-24 04:05:29
Message-ID: 20131024040529.GB6832@eldon.alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Craig Ringer 2013-10-24 04:36:01 How should RLS treat ON DELETE CASCADE, ON UPDATE CASCADE, and ON DELETE SET NULL?
Previous Message Sameer Kumar 2013-10-24 04:01:57 Re: Re: Using indexes for ORDER BY and PARTITION BY clause in windowing functions