Opened 10 years ago

Closed 5 years ago

#5568 closed New feature (fixed)

DROP INDEX subcommand

Reported by: Paul Smith Owned by: nobody
Component: Core (Management commands) Version: master
Severity: Normal Keywords: management sql indexes drop index
Cc: Triage Stage: Accepted
Has patch: yes Needs documentation: no
Needs tests: yes Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

Attached is a patch for a subcommand of django-admin.py that prints DROP INDEX SQL statements for a given app, as in:

$ django-admin.py sqldropindexes my_app
BEGIN;
DROP INDEX my_app_people_name;
DROP INDEX my_app_people_email;
COMMIT;

This is useful for speeding up a big INSERT. Indexes can then be rebuilt with django-admin.py sqlindexes my_app.

Attachments (1)

patch-drop_indexes.diff​ (2.5 KB) - added by Paul Smith 10 years ago.

Download all attachments as: .zip

Change History (7)

Changed 10 years ago by Paul Smith

Attachment: patch-drop_indexes.diff​ added

comment:1 Changed 10 years ago by Paul Smith

Summary: [patch] DROP INDEX subcommand → DROP INDEX subcommand

comment:2 Changed 10 years ago by James Bennett

Triage Stage: Unreviewed → Accepted

comment:3 Changed 6 years ago by Gabriel Hurley

Severity: → Normal
Type: → New feature

comment:4 Changed 6 years ago by Julien Phalip

Easy pickings: unset
Needs tests: set

comment:5 Changed 6 years ago by Aymeric Augustin

UI/UX: unset

Change UI/UX from NULL to False.

comment:6 Changed 5 years ago by Honza Král <Honza.Kral@…>

Resolution: → fixed
Status: new → closed

In e4e12875905ae7360e131e9ef93ce91c638b65fd:

Merge pull request #817 from rybaktomasz/ticket_5568

Fixes #5568 -- DROP INDEX subcommand

Note: See TracTickets for help on using tickets.
Back to Top