Finally, someone acknowledging the pain of non-partitioned indexes in PostgreSQL. This should have been a built-in feature years ago. https://www.reddit.com/user/be_haki