Combine Top-k with similarity search extensions

From: Shmagi Kavtaradze <kavtaradze(dot)s(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Combine Top-k with similarity search extensions
Date: 2015-11-20 10:21:36
Message-ID: CAHY6maz-K9BkY9k4G7fy5AJrgFseYrOi8Oop-7Rz5g=szEywyw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I am performing similarity check over a column in a table with about 3500
entries. Column is populated with text data from text file. Performing a
check results in 3500 * 3500 rows and it takes forever to calculate for my
virtual machine. Is there any way to calculate for top-k results, to
decrease amount and time needed? What I mean is that, for example when
checking two sentences, if first several words does not match, to stop
checking that sentences and move on.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message tim.child 2015-11-20 16:00:30 Re: Combine Top-k with similarity search extensions
Previous Message Shmagi Kavtaradze 2015-11-18 18:34:50 Re: truncate data before importing