Opened 18 years ago

Closed 12 years ago

#5568 closed New feature (fixed)

DROP INDEX subcommand

Reported by: Paul Smith Owned by: nobody
Component: Core (Management commands) Version: dev
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.

Change History (7)

by Paul Smith, 18 years ago

Attachment: patch-drop_indexes.diff​ added

comment:1 by Paul Smith, 18 years ago

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

comment:2 by James Bennett, 18 years ago

Triage Stage: Unreviewed → Accepted

comment:3 by Gabriel Hurley, 14 years ago

Severity: → Normal
Type: → New feature

comment:4 by Julien Phalip, 14 years ago

Easy pickings: unset
Needs tests: set

comment:5 by Aymeric Augustin, 13 years ago

UI/UX: unset

Change UI/UX from NULL to False.

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

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