News for hackers. Stuff that matters.
Re:Creating an advanced search engine with PostgreSQL by riverdroid on Wednesday July 12, 2023 @09:22PM (#36703960)
I was researching this recently and came across this article: 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.

There are no comments on this comment yet.