Gin index for data fields

3 files changed, 109 insertions, 0 deletions

diff --git a/archaeological_operations/migrations/0074_auto_20191216_1013.py b/archaeological_operations/migrations/0074_auto_20191216_1013.py
new file mode 100644
index 000000000..f39299b76
--- /dev/null
+++ b/archaeological_operations/migrations/0074_auto_20191216_1013.py
@@ -0,0 +1,56 @@
+# -*- coding: utf-8 -*-
+# Generated by Django 1.11.18 on 2019-12-16 10:13
+from __future__ import unicode_literals
+
+import django.contrib.postgres.fields.jsonb
+from django.db import migrations
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('archaeological_operations', '0073_auto_20191209_1058'),
+    ]
+
+    operations = [
+        migrations.AlterField(
+            model_name='administrativeact',
+            name='data',
+            field=django.contrib.postgres.fields.jsonb.JSONField(blank=True, default={}),
+        ),
+        migrations.AlterField(
+            model_name='archaeologicalsite',
+            name='data',
+            field=django.contrib.postgres.fields.jsonb.JSONField(blank=True, default={}),
+        ),
+        migrations.AlterField(
+            model_name='historicaladministrativeact',
+            name='data',
+            field=django.contrib.postgres.fields.jsonb.JSONField(blank=True, default={}),
+        ),
+        migrations.AlterField(
+            model_name='historicalarchaeologicalsite',
+            name='data',
+            field=django.contrib.postgres.fields.jsonb.JSONField(blank=True, default={}),
+        ),
+        migrations.AlterField(
+            model_name='historicaloperation',
+            name='data',
+            field=django.contrib.postgres.fields.jsonb.JSONField(blank=True, default={}),
+        ),
+        migrations.AlterField(
+            model_name='operation',
+            name='data',
+            field=django.contrib.postgres.fields.jsonb.JSONField(blank=True, default={}),
+        ),
+        migrations.AlterField(
+            model_name='parcel',
+            name='data',
+            field=django.contrib.postgres.fields.jsonb.JSONField(blank=True, default={}),
+        ),
+        migrations.AlterField(
+            model_name='parcelowner',
+            name='data',
+            field=django.contrib.postgres.fields.jsonb.JSONField(blank=True, default={}),
+        ),
+    ]
diff --git a/archaeological_operations/migrations/0075_auto_20191216_1045.py b/archaeological_operations/migrations/0075_auto_20191216_1045.py
new file mode 100644
index 000000000..615927e43
--- /dev/null
+++ b/archaeological_operations/migrations/0075_auto_20191216_1045.py
@@ -0,0 +1,37 @@
+# -*- coding: utf-8 -*-
+# Generated by Django 1.11.18 on 2019-12-16 10:45
+from __future__ import unicode_literals
+
+import django.contrib.postgres.indexes
+from django.db import migrations
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('archaeological_operations', '0074_auto_20191216_1013'),
+        ('ishtar_common', '0116_create_gist_extension'),
+    ]
+
+    operations = [
+        migrations.AddIndex(
+            model_name='administrativeact',
+            index=django.contrib.postgres.indexes.GinIndex(fields=['data'], name='archaeologi_data_587bb3_gin'),
+        ),
+        migrations.AddIndex(
+            model_name='parcel',
+            index=django.contrib.postgres.indexes.GinIndex(fields=['data'], name='archaeologi_data_835f5e_gin'),
+        ),
+        migrations.AddIndex(
+            model_name='operation',
+            index=django.contrib.postgres.indexes.GinIndex(fields=['data'], name='archaeologi_data_8d8f9f_gin'),
+        ),
+        migrations.AddIndex(
+            model_name='archaeologicalsite',
+            index=django.contrib.postgres.indexes.GinIndex(fields=['data'], name='archaeologi_data_071fb5_gin'),
+        ),
+        migrations.AddIndex(
+            model_name='parcelowner',
+            index=django.contrib.postgres.indexes.GinIndex(fields=['data'], name='archaeologi_data_457021_gin'),
+        ),
+    ]
diff --git a/archaeological_operations/models.py b/archaeological_operations/models.py
index 81dd076a8..ef81acdc9 100644
--- a/archaeological_operations/models.py
+++ b/archaeological_operations/models.py
@@ -26,6 +26,7 @@ from django.conf import settings
 from django.contrib.gis.db import models
 from django.contrib.gis.db.models.aggregates import Union
 from django.contrib.gis.db.models.functions import Centroid
+from django.contrib.postgres.indexes import GinIndex
 from django.core.urlresolvers import reverse
 from django.db import IntegrityError, transaction
 from django.db.models import Q, Count, Sum, Max, Avg
@@ -367,6 +368,9 @@ class ArchaeologicalSite(DocumentItem, BaseHistorizedItem, QRCodeItem,
             ("delete_own_archaeologicalsite",
              "Can delete own Archaeological site"),
         )
+        indexes = [
+            GinIndex(fields=['data']),
+        ]
 
     def __str__(self):
         return self.cached_label or ''
@@ -1124,6 +1128,9 @@ class Operation(ClosedItem, DocumentItem, BaseHistorizedItem, QRCodeItem,
             ("close_operation", "Can close Operation"),
         )
         ordering = ('cached_label',)
+        indexes = [
+            GinIndex(fields=['data']),
+        ]
 
     def natural_key(self):
         return (self.uuid, )
@@ -2099,6 +2106,9 @@ class AdministrativeAct(BaseHistorizedItem, OwnPerms, ValueGetter):
             ("delete_own_administrativeact",
              "Can delete own Administrative act"),
         )
+        indexes = [
+            GinIndex(fields=['data']),
+        ]
 
     @property
     def DELETE_URL(self):
@@ -2317,6 +2327,9 @@ class Parcel(LightHistorizedItem):
         verbose_name = _("Parcel")
         verbose_name_plural = _("Parcels")
         ordering = ('year', 'section', 'parcel_number')
+        indexes = [
+            GinIndex(fields=['data']),
+        ]
 
     @property
     def short_label(self):
@@ -2533,6 +2546,9 @@ class ParcelOwner(LightHistorizedItem):
     class Meta:
         verbose_name = _("Parcel owner")
         verbose_name_plural = _("Parcel owners")
+        indexes = [
+            GinIndex(fields=['data']),
+        ]
 
     def __str__(self):
         return "{}{}{}".format(self.owner, settings.JOINT, self.parcel)