I was researching this recently and came across this article: https://pganalyze.com/blog/gin-index https://pganalyze.com/blog/gin-index The GIN index has some

I was researching this recently and came across this article: https://pganalyze.com/blog/gin-index https://pganalyze.com/blog/gin-index The GIN index has some similarities to Elasticsearch's inverted indices (last I knew anyway), which also can be quite expensive to write to. If you're doing heavy writes, something to test and consider carefully. TLDR; writes get a lot more expensive with GIN indices.