python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - postgresql-performance

Intersection of SQL statements efficiently

I'm trying to solve a SQL problem where I need to select the data in a certain intersection. This is more or less my query: SELECT id FROM some_table WHERE id IN (SELECT id FROM other_table WHERE _id=...
test-img

Antonio Gamiz Delgado

sql

postgresql

intersection

postgresql-performance

Votes: 0

Answers: 1

Latest Answer

I'm still unclear on what you're after w/o sample data expected results: but would either of these options work? inner join ... SELECT id FROM some_table A INNER JOIN (SELECT id FROM other_table WHER...
test-img

xQbert

Optimize PostgreSQL query with levenshtein() function

I have a table with approximately 7 million records. The table has a first_name and last_name column which I want to search on using the levenshtein() distance function. select levenshtein('JOHN', fir...
test-img

user1452701

postgresql

postgresql-10

postgresql-performance

Votes: 0

Answers: 1

Latest Answer

There is no built-in index type that supports levenshtein distances. I'm not aware of any 3rd party index implementations to do so either. Another string similarity measure, trigram similarity, does ...
test-img

jjanes

Posts

Questions

Blogs

Jobs