svn commit: r1476840 - /manifoldcf/trunk/framework/pull-agent/src/main/java/org/apache/manifoldcf/crawler/jobs/PrereqEventManager.java

[kw...@apache.org]

Author: kwright
Date: Sun Apr 28 21:16:24 2013
New Revision: 1476840

URL: http://svn.apache.org/r1476840
Log:
Remove index proposed by postgresql team, when it turned out that the index did not help.

Modified:
    manifoldcf/trunk/framework/pull-agent/src/main/java/org/apache/manifoldcf/crawler/jobs/PrereqEventManager.java

Modified: manifoldcf/trunk/framework/pull-agent/src/main/java/org/apache/manifoldcf/crawler/jobs/PrereqEventManager.java
URL: http://svn.apache.org/viewvc/manifoldcf/trunk/framework/pull-agent/src/main/java/org/apache/manifoldcf/crawler/jobs/PrereqEventManager.java?rev=1476840&r1=1476839&r2=1476840&view=diff
==============================================================================
--- manifoldcf/trunk/framework/pull-agent/src/main/java/org/apache/manifoldcf/crawler/jobs/PrereqEventManager.java (original)
+++ manifoldcf/trunk/framework/pull-agent/src/main/java/org/apache/manifoldcf/crawler/jobs/PrereqEventManager.java Sun Apr 28 21:16:24 2013
@@ -78,7 +78,8 @@ public class PrereqEventManager extends 
 
       // Index management
       IndexDescription ownerIndex = new IndexDescription(false,new String[]{ownerField});
-      IndexDescription eventNameIndex = new IndexDescription(false,new String[]{eventNameField});
+      // eventNameIndex was proposed by postgresql team, but it did not help, so I am removing it.
+      //IndexDescription eventNameIndex = new IndexDescription(false,new String[]{eventNameField});
 
       // Get rid of indexes that shouldn't be there
       Map indexes = getTableIndexes(null,null);
@@ -90,8 +91,8 @@ public class PrereqEventManager extends 
 
         if (ownerIndex != null && id.equals(ownerIndex))
           ownerIndex = null;
-        else if (eventNameIndex != null && id.equals(eventNameIndex))
-          eventNameIndex = null;
+        //else if (eventNameIndex != null && id.equals(eventNameIndex))
+        //  eventNameIndex = null;
         else if (indexName.indexOf("_pkey") == -1)
           // This index shouldn't be here; drop it
           performRemoveIndex(indexName);
@@ -100,8 +101,8 @@ public class PrereqEventManager extends 
       // Add the ones we didn't find
       if (ownerIndex != null)
         performAddIndex(null,ownerIndex);
-      if (eventNameIndex != null)
-        performAddIndex(null,eventNameIndex);
+      //if (eventNameIndex != null)
+      //  performAddIndex(null,eventNameIndex);
 
       break;
     }