PostgreSQL Partition Pruning for Non-Partition Key QueriesThis article addresses a common PostgreSQL optimization challenge: partition pruning normally only works when filtering by the...
Things I want in a modern relational query languageTechnical essay exploring how functional programming concepts and modern language design could improve relational database query languages, featuring practical examples of pattern matching, sum types, and discriminated unions for SQL.