Eh you could implement this pretty simply with postgres table partitions

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