Creating a GIN index in Django

Question

I have created a model in Django.

class MyModel(models.Model):
    features = TextField(blank=True, default='')

There are several possible ways to store the data in the feature field. Some examples below.

feature1;feature2
feature1, feature2
feature1,feature2

And so on. I need to create a GIN index for that field. I would probably do it in postgreSQL in the following way

CREATE INDEX features_search_idx ON "mymodel" USING gin (regexp_split_to_array("mymodel"."features", E'[,;\\s]+'));

Would it be possible to do the same thing by a migration?

AKX · Accepted Answer · 2021-11-25 11:00:55Z

2

Yes.

Create an empty migration: python manage.py makemigration yourapp --empty -n pour_gin
Add a migrations.RunSQL() operation in the migration file.

class Migration(migrations.Migration):

    dependencies = [
        # ...
    ]
    operations = [
        migrations.RunSQL(
            sql="""CREATE INDEX features_search_idx ON "mymodel" USING gin (regexp_split_to_array("mymodel"."features", E'[,;\\s]+'));""",
            reverse_sql=migrations.RunSQL.noop,  # TODO: replace me with DROP INDEX
        ),
    ]

answered Nov 25, 2021 at 11:00

AKX

171k16 gold badges147 silver badges229 bronze badges

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

2 Comments

Hendrra Over a year ago

Is DROP INDEX essential?

AKX Over a year ago

If you want to be able to undo the migration at any point, it'd be nice to have.

Collectives™ on Stack Overflow

Creating a GIN index in Django

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related