Ah, that's an interesting idea! I had never considered using partitions. I might write a followup post with these new ideas.

There are a bunch of caveats around primary keys and uniqueness but I suspect it could be made to work depending on your data model.