I recently learned that Postgres supports full text search:

https://blog.crunchydata.com/blog/postgres-full-text-search-a-search-engine-in-a-database

(It's supported this for a long time but I'm late to the party.)

The single biggest pain for me running a small Mastodon/Hometown instance is running Elasticsearch alongside it. I was wondering: has anyone looked into either 1) supporting postgres for text search on Mastodon, 2) providing an API frontend for postgres that mimicks the Elasticsearch API?