Question

0

248

Views

Creating a GIN index in Django

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?

over 4 years ago · Santiago Trujillo

1 answers

Answer question

0

Answer question

Find remote jobs

Accepted Answer · 2022-04-19T20:25:31.484Z

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
        ),
    ]

0

248

Creating a GIN index in Django

1 answers

0

Find remote jobs

Andres GPT