Native vs Amgix Full-Text Search Performance on PostgreSQL and MariaDB
Amgix works with your choice of a backend: PostgreSQL, MariaDB, or Qdrant. Each of those backends comes with its own built-in Full-Text Search (FTS). In this post we will focus on how search relevance and performance compare between SQL native FTS and Amgix on the same backends.
Before we ran the tests we made a couple of assumptions:
- Native FTS will always be faster.
- Amgix relevance should be a little better.
We were wrong on both counts: not always and not a little.