3 ms·
> Maria supports partitioning, Postgres (as of my last knowledge) does not. PostgreSQL's manual indicates that partitioning is a thing[1]. Is the something di
by floating-io 2y ago
> 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.html https://www.postgresql.org/docs/current/ddl-partitioning.htm...
- justinclift 2y ago> based on the time period Is it the kind of thing where the TimescaleDB extension would make sense? https://github.com/timescale/timescaledb https://github.com/timescale/timescaledb
- floating-io 2y agoIn 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.