Opened 3 years ago
Last modified 3 years ago
#34489 closed New feature
feature: Support for PostgreSQL table partitioning — at Version 1
| 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 (last modified by )
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.