Add index on versions table.

diff --git a/pithos/backends/lib/node.py b/pithos/backends/lib/node.py
index 2bad014..867e44d 100644 (file)
--- a/pithos/backends/lib/node.py
+++ b/pithos/backends/lib/node.py
@@ -138,11 +138,8 @@ class Node(DBWorker):
                             references nodes(node)
                             on update cascade
                             on delete cascade ) """)
-        execute(""" create index if not exists idx_versions_node
-                    on versions(node) """)
-        # TODO: Sort out if more indexes are needed.
-        # execute(""" create index if not exists idx_versions_mtime
-        #             on versions(mtime) """)
+        execute(""" create index if not exists idx_versions_node_mtime
+                    on versions(node, mtime) """)
         
         execute(""" create table if not exists attributes
                           ( serial integer,