Index: openacs-4/packages/forums/forums.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/forums.info,v
diff -u -N -r1.56.2.11 -r1.56.2.12
--- openacs-4/packages/forums/forums.info	26 Sep 2020 12:10:23 -0000	1.56.2.11
+++ openacs-4/packages/forums/forums.info	6 Oct 2020 08:23:19 -0000	1.56.2.12
@@ -9,7 +9,7 @@
     <implements-subsite-p>f</implements-subsite-p>
     <inherit-templates-p>t</inherit-templates-p>
 
-    <version name="1.4.0d2" url="http://openacs.org/repository/download/apm/forums-1.4.0d2.apm">
+    <version name="1.4.0d3" url="http://openacs.org/repository/download/apm/forums-1.4.0d3.apm">
         <owner url="http://openacs.org">OpenACS</owner>
         <summary>Online discussion forums.</summary>
         <release-date>2017-08-06</release-date>
@@ -19,7 +19,7 @@
         <maturity>2</maturity>
         <package_instance_name>#forums.Forums#</package_instance_name>
 
-        <provides url="forums" version="1.4.0d2"/>
+        <provides url="forums" version="1.4.0d3"/>
         <requires url="acs-kernel" version="5.9.1"/>
         <requires url="acs-tcl" version="5.10.0d39"/>
         <requires url="acs-mail-lite" version="5.9.1"/>
Index: openacs-4/packages/forums/sql/postgresql/forums-reading-info-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/postgresql/forums-reading-info-create.sql,v
diff -u -N -r1.6.2.1 -r1.6.2.2
--- openacs-4/packages/forums/sql/postgresql/forums-reading-info-create.sql	6 Oct 2020 08:20:33 -0000	1.6.2.1
+++ openacs-4/packages/forums/sql/postgresql/forums-reading-info-create.sql	6 Oct 2020 08:23:19 -0000	1.6.2.2
@@ -24,6 +24,7 @@
 create index forums_reading_info_user_index on forums_reading_info (user_id);
 create index forums_reading_info_forum_message_index on forums_reading_info (root_message_id);
 create index forums_reading_info_forum_forum_index on forums_reading_info (forum_id);
+create index forums_reading_info_user_id_root_message_id_idx on forums_reading_info(user_id,root_message_id);
 
 create or replace view forums_reading_info_user as
    select forum_id,
Index: openacs-4/packages/forums/sql/postgresql/upgrade/upgrade-1.4d2-1.4d3.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/postgresql/upgrade/Attic/upgrade-1.4d2-1.4d3.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/forums/sql/postgresql/upgrade/upgrade-1.4d2-1.4d3.sql	6 Oct 2020 08:23:19 -0000	1.1.2.1
@@ -0,0 +1,3 @@
+
+-- New index on the forums_reading_info table
+create index if not exists forums_reading_info_user_id_root_message_id_idx on forums_reading_info(user_id,root_message_id);