Making a Postgres query 1,000 times faster
mattermost.com
Making a Postgres query 1,000 times faster
7 must-know strategies to scale your database
Indexing:
Check the query patterns of your application and create the right indexes.
Materialized Views:
Pre-compute complex query results and store them for faster access.
Denormalization:
Reduce complex joins to improve query performance.
Vertical Scaling
Boost your database server by adding more CPU, RAM, or... See more
Indexing:
Check the query patterns of your application and create the right indexes.
Materialized Views:
Pre-compute complex query results and store them for faster access.
Denormalization:
Reduce complex joins to improve query performance.
Vertical Scaling
Boost your database server by adding more CPU, RAM, or... See more
Shortwave — rajhesh.panchanadhan@gmail.com [Gmail alternative]
Another observation I’ve made is that starting with a performant core can ultimately drastically simplify the architecture of a software project, relative to a given level of functionality.
Nelson Elhage • Reflections on software performance
Scaling Causal's Spreadsheet Engine From Thousands to Billions of Cells: From Maps to Arrays
Simon Eskildsen (simon@sirupsen.com)sirupsen.comAstro DB
astro.build