Is Postgres ever going to allow automatic partitioning?

Something like:

    CREATE TABLE logs (
      time TIMESTAMPTZ,
      data JSONB  
    ) PARTITION ON time IN INTERVAL '1 day'

And it just creates/manages these partitions for every day?

If you can already manage partitions like this manually it feels like the next step is to just have it be automatic. So you have less of a need to switch to Timescale or ClickHouse or whatever other database as the amount of data you're storing/querying grows. (Yeah that's a handwave-y suggestion but at least you could stick with Postgres for longer.)

pg_partman, which is included in most distributions of Postgres (including RDS) can handle some cases

- https://github.com/pgpartman/pg_partman

- https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Postg...