Opened 19 months ago

Last modified 15 months ago

#21039 new New feature

Support Postgres "CREATE INDEX CONCURRENTLY" in migrations

Reported by: FunkyBob Owned by:
Component: Migrations Version: master
Severity: Normal Keywords:
Cc: Triage Stage: Accepted
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

When a migration creates a new index, it's sometimes preferable to use a concurrent index creation so it won't interfere with the operation of the DB:

http://www.postgresql.org/docs/9.2/static/sql-createindex.html#SQL-CREATEINDEX-CONCURRENTLY

It would be nice to have an option to enable this in migrations.

Change History (3)

comment:1 Changed 19 months ago by jcatalan

  • Needs documentation unset
  • Needs tests unset
  • Owner set to jcatalan
  • Patch needs improvement unset
  • Status changed from new to assigned

comment:2 Changed 19 months ago by timo

  • Triage Stage changed from Unreviewed to Accepted

comment:3 Changed 15 months ago by andrewgodwin

  • Owner jcatalan deleted
  • Status changed from assigned to new

This won't make it into 1.7, as it's too big of a change.

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