FRESH
Hacker News
How to Achieve Pruning When Querying by Non-Partitioned Columns in PostgreSQL
13 points by theanonymousone
- 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