Django : db_index and makemigrations

Question

I want to add to existing fields some db_index in my models. I just added db_index=Trueto the model.

I was thinking I would need to run python manage.py migrateto apply them on the database. My issue is that no change is detected thus no migration is created. Is it a normal behavior ?

Or is there a specific behavior I'm not aware of?

Thank you.

Django 1.7 right now, planning to make a migration to Django 1.9 soon. — Alex Grs
– Alex Grs, Commented Dec 3, 2015 at 18:17

Community · Accepted Answer · 2017-05-23 10:29:44Z

1

If you know enough of SQL, you can still create the migration by hand using RunSQL.

For example: (with PostgreSQL syntax)

class Migration(migrations.Migration):

    dependencies = [
        ('your_app', '0001_initial'), # or last mig
    ]

    operations = [
        migrations.RunSQL("CREATE INDEX my_table_my_column_ind ON my_table (my_colum)"),
    ]

Related: Creating Partial Indexes with Django 1.7

edited May 23, 2017 at 10:29

CommunityBot

11 silver badge

answered Dec 3, 2015 at 19:01

stellasia

5,6624 gold badges27 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

doniyor · Accepted Answer · 2015-12-03 18:04:34Z

0

you can use index_together

class YourModel(models.Model):
    # ...

    class Meta:
        index_together = ["field_that_needs_index"]

then makemigration should work

answered Dec 3, 2015 at 18:04

doniyor

38k62 gold badges183 silver badges272 bronze badges

4 Comments

Alex Grs Over a year ago

Is there really no way to only add db_index? I have 2 / 3 indexes to create on my models ?

doniyor Over a year ago

set the db_index in the fields also, but you need migration for it, so add these fields in index_together also.

Alex Grs Over a year ago

Ok. how can I check then that my indexes are created ? Creating thos index_together will not cause issues with writes / or database size ?

doniyor Over a year ago

@AlexGrs nope, no issues. SHOW INDEX FROM [tablename] will show you the indexes from your tables

Collectives™ on Stack Overflow

Django : db_index and makemigrations

2 Answers 2

Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related