"Should we switch to Postgres" is a bit of a tongue-in-cheek comment on the desire to switch tools when things get tricky, not a real suggestion in this case.

"Should we switch to Postgres" is a bit of a tongue-in-cheek comment on the desire to switch tools when things get tricky, not a real suggestion in this case. To my knowledge, Postgres' %TEXT% pattern matching would behave very similarly to MySQL's, given the lack of indexing. From the Postgres docs[0]: > Textual search operators have existed in databases for years. PostgreSQL has ~, ~*, LIKE, and ILIKE operators for textual data types, but they lack many essential properties required by modern information systems: > > ... > They tend to be slow because there is no index support, so they must process all documents for every search. [0] - https://www.postgresql.org/docs/9.5/textsearch-intro.html#TEXTSEARCH-MATCHING https://www.postgresql.org/docs/9.5/textsearch-intro.html#TE...