It's much better to use elastic (or solr) and keep your text indices out of the database. They have more features and you keep the load separate. This is import

It's much better to use elastic (or solr) and keep your text indices out of the database. They have more features and you keep the load separate. This is important if you suddenly have to index a ton of new documents or even recreate your indices. I used to keep text indices in Oracle and it would take days to sync them. There's even a Postgresql Foreign Data Wrapper for elastic, so you can integrate them easily. One project I witnessed used Postgresql solely as a middle man between the main database and Elastic.