Efficient Text Search for Large Term List: Python vs PostgreSQL vs Elasticsearch
I have a list containing terms that vary in length from 1 to 10 words, with approximately 500,000 entries. My goal is to search for these terms in a long text (converted from a PDF, typically 1.5 to 2 pages…