From 8e4c9c30b6d71ceea49e8879975518992b13dd66 Mon Sep 17 00:00:00 2001
From: Ant Zucaro <azucaro@gmail.com>
Date: Wed, 24 Dec 2014 13:28:59 -0500
Subject: [PATCH] The games table gets a gin index on players.

---
 scripts/gen_partitions.shl | 6 ++++++
 1 file changed, 6 insertions(+)

diff --git a/scripts/gen_partitions.shl b/scripts/gen_partitions.shl
index 5c47605..b687eef 100755
--- a/scripts/gen_partitions.shl
+++ b/scripts/gen_partitions.shl
@@ -40,6 +40,12 @@ do
         then
             printf "CREATE INDEX %s_%s%s_ix002 on %s_%s%s(game_id);\n" $table $year $qtr $table $year $qtr
         fi
+
+        if [[ $table = "games" ]]
+        then
+            printf "CREATE INDEX %s_%s%s_ix002 on %s_%s%s using gin(players);\n" $table $year $qtr $table $year $qtr
+        fi
+
         printf "\n"
     done
 done
-- 
2.39.2