Partial indexes: indexing selected rows
use-the-index-luke.com
Saved by Franco Passeggi
Partial indexes: indexing selected rows
7 must-know strategies to scale your database.
1 - Indexing:
Check the query patterns of your application and create the right indexes.
2 - Materialized Views:
Pre-compute complex query results and store them for faster access.
___LINEBREAK__... See more
A curated collection of gems and books for building and optimizing #rails apps with #PostgreSQL
https://t.co/XXRsTN7dP1
Alex Yarotskyx.comImproving query performance in ElasticSearch at scale
blogs.halodoc.io