My christmas present for you:
I've extracted an internal Elixir library that auto rotates partitioned tables in Postgres and created an open source hex package of it.
https://hex.pm/packages/partitioned_schema
For the 1.0.0 I need to polish the readme and add some typespecs. But it works and is actually a lot safer and capable than the old library I've been using for years in various projects.
Very useful for data that you don't want to keep forever like metrics.