Opened 2 hours ago
Last modified 2 hours ago
#35936 assigned Cleanup/optimization
Speeding up Postgres bulk_create by using unnest
| Reported by: | Simon Charette | Owned by: | Simon Charette |
|---|---|---|---|
| Component: | Database layer (models, ORM) | Version: | 5.1 |
| Severity: | Normal | Keywords: | postgres bulk create unnest |
| Cc: | Triage Stage: | Unreviewed | |
| Has patch: | yes | Needs documentation: | no |
| Needs tests: | no | Patch needs improvement: | yes |
| Easy pickings: | no | UI/UX: | no |
Description
Per this forum discussion there seems to be a consensus and peer validation of performance benefits of using unnest for the bulk insertion of literal values on Postgres.
Change History (1)
comment:1 by , 2 hours ago
| Has patch: | set |
|---|---|
| Owner: | set to |
| Patch needs improvement: | set |
| Status: | new → assigned |
Note:
See TracTickets
for help on using tickets.