Opened 8 years ago

Closed 2 years ago

#5568 closed New feature (fixed)

DROP INDEX subcommand

Reported by: p 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 p 8 years ago.

Download all attachments as: .zip

Change History (7)

Changed 8 years ago by p

comment:1 Changed 8 years ago by p

  • Needs documentation unset
  • Needs tests unset
  • Patch needs improvement unset
  • Summary changed from [patch] DROP INDEX subcommand to DROP INDEX subcommand

comment:2 Changed 8 years ago by ubernostrum

  • Triage Stage changed from Unreviewed to Accepted

comment:3 Changed 4 years ago by gabrielhurley

  • Severity set to Normal
  • Type set to New feature

comment:4 Changed 4 years ago by julien

  • Easy pickings unset
  • Needs tests set

comment:5 Changed 3 years ago by aaugustin

  • UI/UX unset

Change UI/UX from NULL to False.

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

  • Resolution set to fixed
  • Status changed from new to 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