MyISAM is considered deprecated at this point. It isn't crash-safe and basically should not be used at all, let alone for a new project. InnoDB has supported f

MyISAM is considered deprecated at this point. It isn't crash-safe and basically should not be used at all, let alone for a new project. InnoDB has supported fulltext indexes since 5.6 (GA release back in feb 2013). However, to be fair, fulltext indexes in InnoDB are not widely used and have a mixed reputation at best. Large MySQL-based companies tend to lean on external search services e.g. Solr. I'm not familiar enough with pg's fulltext to compare. I would expect the functionality is superior to InnoDB's, but I am genuinely curious whether large pg-based companies rely on it solely vs using an external search index service.