SQLite's FTS5 is really killer, and best still, in-built, compared to PostgreSQL's need for all these other plugins. Consider that before moving to PostgreSQL.