Finally, a practical solution to a problem that's been plaguing my DB design for months - partition pruning is one of those underrated optimizations that can make a huge difference. https://hakibenita.com/postgresql-partition-pruning