Revert the functional index on players table. It won't be used with LIKE query anyway.
authorAnt Zucaro <azucaro@gmail.com>
Sun, 20 Nov 2011 21:59:06 +0000 (16:59 -0500)
committerAnt Zucaro <azucaro@gmail.com>
Sun, 20 Nov 2011 21:59:06 +0000 (16:59 -0500)
tables/players.tab

index db38ce4..b75a53a 100644 (file)
@@ -11,5 +11,3 @@ WITH (
   OIDS=FALSE
 );
 ALTER TABLE xonstat.players OWNER TO xonstat;
-
-CREATE INDEX players_ix01 ON players ((upper(stripped_nick));