If you're using Postgres Trigram indexes at larger scales, I might suggest reading over just the conclusions at the end of my article here: https://devlog.hexo

If you're using Postgres Trigram indexes at larger scales, I might suggest reading over just the conclusions at the end of my article here: https://devlog.hexops.com/2021/postgres-regex-search-over-10000-github-repositories https://devlog.hexops.com/2021/postgres-regex-search-over-10... e.g. I discuss the fact that pg_tgrm indexes being built does not take advantage of multiple cores, so at large scales you'll benefit from splitting data into multiple tables.