[floating-io]

> Maria supports partitioning, Postgres (as of my last knowledge) does not.

PostgreSQL's manual indicates that partitioning is a thing[1]. Is the something different than what you're thinking of?

One of my projects has the need to drop millions of rows a month based on the time period, and I've been considering a switch to postgres because they also have a module that will do that automatically.

What am I missing?

[1] https://www.postgresql.org/docs/current/ddl-partitioning.htm...

[justinclift]

> based on the time period

Is it the kind of thing where the TimescaleDB extension would make sense?

https://github.com/timescale/timescaledb

[floating-io]

In my case, pg_partman is actually more than enough. It's just a situation where the data isn't useful after a certain point. Timescale as I understand it would be massive overkill for my situation.