Opened 19 months ago
Last modified 19 months ago
#34489 closed New feature
feature: Support for PostgreSQL table partitioning — at Initial Version
Reported by: | Anuj Sharma | Owned by: | nobody |
---|---|---|---|
Component: | Database layer (models, ORM) | Version: | 4.2 |
Severity: | Normal | Keywords: | postgresql, table-partitioning, composite primary key |
Cc: | Triage Stage: | Unreviewed | |
Has patch: | no | Needs documentation: | no |
Needs tests: | no | Patch needs improvement: | no |
Easy pickings: | no | UI/UX: | no |
Description
Postgresql added support for table partitioning from 10.x; currently, it is on 15.x.
Django should add support for PostgreSQL table partitioning so that the database engine can be used efficiently.
Currently, I can only see one library supporting partitioning (django-postgres-extra)https://django-postgres-extra.readthedocs.io/en/latest/table_partitioning.html. Still, it also has limitations in migration because Django does not support composite primary key, which is the key requirement for the Postgres table partitioning.