Gin index for data fields

1 files changed, 10 insertions, 0 deletions

diff --git a/archaeological_warehouse/models.py b/archaeological_warehouse/models.py
index de567d26e..64a766cea 100644
--- a/archaeological_warehouse/models.py
+++ b/archaeological_warehouse/models.py
@@ -22,6 +22,7 @@ import uuid
 
 from django.conf import settings
 from django.contrib.gis.db import models
+from django.contrib.postgres.indexes import GinIndex
 from django.core.urlresolvers import reverse
 from django.db.models import Q, Max
 from django.db.models.signals import post_save, post_delete, m2m_changed
@@ -134,6 +135,9 @@ class Warehouse(Address, DocumentItem, GeoItem, QRCodeItem, DashboardFormItem,
             ("change_own_warehouse", u"Can change own Warehouse"),
             ("delete_own_warehouse", u"Can delete own Warehouse"),
         )
+        indexes = [
+            GinIndex(fields=['data']),
+        ]
 
     def __str__(self):
         return self.name
@@ -359,6 +363,9 @@ class Collection(LightHistorizedItem):
         verbose_name = _(u"Collection")
         verbose_name_plural = _(u"Collection")
         ordering = ('name',)
+        indexes = [
+            GinIndex(fields=['data']),
+        ]
 
     def __str__(self):
         return self.name
@@ -639,6 +646,9 @@ class Container(DocumentItem, LightHistorizedItem, QRCodeItem, GeoItem,
             ("change_own_container", u"Can change own Container"),
             ("delete_own_container", u"Can delete own Container"),
         )
+        indexes = [
+            GinIndex(fields=['data']),
+        ]
 
     def __str__(self):
         return self.cached_label or ""