2 ms·
Oh cool I didn't know PostgreSQL can use those for regular expressions! I was playing with those indexes for PostgreSQL just this morning: https://til.simonwill
by simonw 6y ago
Oh cool I didn't know PostgreSQL can use those for regular expressions! I was playing with those indexes for PostgreSQL just this morning: https://til.simonwillison.net/django/enabling-gin-index https://til.simonwillison.net/django/enabling-gin-index
- slimsag 6y agoIf 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.