How to Achieve Pruning When Querying by Non-Partitioned Columns in PostgreSQL(hakibenita.com)
hakibenita.com
How to Achieve Pruning When Querying by Non-Partitioned Columns in PostgreSQL
https://hakibenita.com/postgresql-partition-pruning
1 comments
I'm drawn to this but it has several foot guns like INSERTs will fail for late arriving data if the constraints have been updated etc