3 files changed, 20 insertions, 2 deletions
diff --git a/database/database.mysql b/database/database.mysql
index 88126a0fb..3b3f86643 100644
--- a/database/database.mysql
+++ b/database/database.mysql
@@ -334,7 +334,9 @@ CREATE TABLE node (
   KEY status (status),
   KEY uid (uid),
   KEY node_moderate (moderate),
-  KEY node_promote_status (promote, status)
+  KEY node_promote_status (promote, status),
+  KEY node_created (created),
+  KEY node_changed (changed)
 ) TYPE=MyISAM;
 
 --
diff --git a/database/database.pgsql b/database/database.pgsql
index 73c737a33..65a18c73c 100644
--- a/database/database.pgsql
+++ b/database/database.pgsql
@@ -336,6 +336,8 @@ CREATE INDEX node_status_idx ON node(status);
 CREATE INDEX node_uid_idx ON node(uid);
 CREATE INDEX node_moderate_idx ON node (moderate);
 CREATE INDEX node_promote_status_idx ON node (promote, status);
+CREATE INDEX node_created ON node(created);
+CREATE INDEX node_changed ON node(changed);
 
 --
 -- Table structure for table 'node_counter'
diff --git a/database/updates.inc b/database/updates.inc
index ef53af326..1f200ed55 100644
--- a/database/updates.inc
+++ b/database/updates.inc
@@ -61,7 +61,8 @@ $sql_updates = array(
   "2004-05-18" => "update_87",
   "2004-06-11" => "update_88",
   "2004-06-18" => "update_89",
-  "2004-06-27" => "update_90"
+  "2004-06-27" => "update_90",
+  "2004-06-30" => "update_91"
 );
 
 function update_32() {
@@ -1128,6 +1129,19 @@ function update_90() {
   return $ret;
 }
 
+function update_91() {
+  $ret = array();
+  if ($GLOBALS["db_type"] == "pgsql") {
+    $ret[] = update_sql("CREATE INDEX node_created ON {node} (created)");
+    $ret[] = update_sql("CREATE INDEX node_changed ON {node} (changed)");
+  }
+  else {
+    $ret[] = update_sql("ALTER TABLE {node} ADD INDEX node_created (created)");
+    $ret[] = update_sql("ALTER TABLE {node} ADD INDEX node_changed (changed)");
+  }
+  return $ret;
+}
+
 function update_sql($sql) {
   $edit = $_POST["edit"];
   $result = db_query($sql);