2 ms·
Actually, I’ve done tests with an indexed postgres database of several gigabytes size and tsvector for stemming and co vs. ElasticSearch. At least until you re
by kuschku 10y ago
Actually, I’ve done tests with an indexed postgres database of several gigabytes size and tsvector for stemming and co vs. ElasticSearch.
At least until you reach several hundred gigabytes, postgres uses less resources for the same search speed.
This video shows searching through 3 GB of IRC logs, filtering, ranking them based on similarity to the query, creation time, likelyhood that it’s the type of message the user wants, highlighting the part of the message with the matching words, and displaying all that:
https://dl.kuschku.de/videos/2016-09-16_04-03-36.mp4 https://dl.kuschku.de/videos/2016-09-16_04-03-36.mp4
Postgres is, for smaller amounts of data, more than fast enough.