[buchanae]

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

[tempest_]

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.