Databases

Learnings from the book Designing Data-Intensive Applications

These are my learnings from the book Designing Data-Intensive Applications

PostgreSQL's GIN index: Long random queries can happen on data updates

We were seeing random queries taking as much a 35 seconds on our Postgres DB. The cause was GIN index feature that you have to get to know