Code

Opened 8 months ago

Last modified 4 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.

Attachments (0)

Change History (3)

comment:1 Changed 8 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 8 months ago by timo

  • Triage Stage changed from Unreviewed to Accepted

comment:3 Changed 4 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.

Add Comment

Modify Ticket

Change Properties
<Author field>
Action
as new
The owner will be changed from (none) to anonymous. Next status will be 'assigned'
as The resolution will be set. Next status will be 'closed'
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.