Django PostgreSQL JSONField db_index error

Question

My model:

from django.db import models
from django.contrib.postgres.fields import JSONField

class MyModel(models.Model):
    data = JSONField(blank=True, null=True)

I have created some objects and filled "data" field with some JSONs

Then I tried to create index for "data" field

class MyModel(models.Model):
    data = JSONField(blank=True, null=True, db_index=True)

Make migrations

python manage.py makemigrations

Migrate

python manage.py migrate

Long traceback, and last line is:

django.db.utils.OperationalError: index row requires 8336 bytes, maximum size is 8191

How can I fix it?

Community · Accepted Answer · 2017-04-13 12:42:36Z

3

As you can see from this answer, this is a limitation of the b-tree index. There is no simple solution to this. Indexing an entire JSONField also doesn't really make any sense. For what reason are you attempting to index the JSONField in the first place?

My recommendation would be to remove this index, as I doubt it is required. You may wish to try a more complex index, but Django's built in db_index is not capable of this. You'd have to create a more custom approach based on your situation.

edited Apr 13, 2017 at 12:42

CommunityBot

11 silver badge

answered Oct 21, 2016 at 21:29

Jamie Counsell

8,1646 gold badges55 silver badges86 bronze badges

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

1 Comment

MaxCore Over a year ago

Big thx for information. I just wanted to make performance test.

Collectives™ on Stack Overflow

Django PostgreSQL JSONField db_index error

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related