Speed up queries¶
cache common operations
EXPLAIN ANALYZE to see what it's doing
[[PSQL Query Optimization]]
- indexing strategically
Partitioning by application function
Sharding as a last resort
Last update:
2023-04-24
cache common operations
EXPLAIN ANALYZE to see what it's doing
[[PSQL Query Optimization]]
Partitioning by application function
Sharding as a last resort