I guess that works well with NoSQL. In a relational database it gets harder to move record out if they have relationships with other tables.

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.

	▲	tempest_ 6 hours ago \| parent [-]
		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.