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-10

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

Postgres "invalid input syntax for type oid:"

I am using Postgres 10 on Centos (PostgreSQL 10.17 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit) When I execute the SQL statement below I receive the error &...
test-img

norris-md

postgresql

postgresql-10

Votes: 0

Answers: 1

Latest Answer

UPDATE If I execute SELECT persistenceid, process_id, process_id AS case_id, completed_date_time, created_date_time::timestamp AT TIME ZONE 'EST' AS created_date_time, status, customer_i...
test-img

norris-md

Posts

Questions

Blogs

Jobs