Index: openacs-4/packages/acs-kernel/acs-kernel.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/acs-kernel.info,v
diff -u -N -r1.150.2.49 -r1.150.2.50
--- openacs-4/packages/acs-kernel/acs-kernel.info	11 Oct 2022 09:17:12 -0000	1.150.2.49
+++ openacs-4/packages/acs-kernel/acs-kernel.info	1 Dec 2022 16:39:48 -0000	1.150.2.50
@@ -9,15 +9,15 @@
     <implements-subsite-p>f</implements-subsite-p>
     <inherit-templates-p>t</inherit-templates-p>
 
-    <version name="5.10.1d13" url="http://openacs.org/repository/download/apm/acs-kernel-5.10.1d13.apm">
+    <version name="5.10.1d14" url="http://openacs.org/repository/download/apm/acs-kernel-5.10.1d14.apm">
         <owner url="mailto:oct@openacs.org">OpenACS Core Team</owner>
         <summary>Routines and data models providing the foundation for OpenACS-based Web services.</summary>
         <release-date>2021-09-15</release-date>
         <vendor url="http://openacs.org">OpenACS</vendor>
         <description format="text/html">The OpenACS kernel contains the core datamodel create and drop scripts for such things as objects, groups, parties and the supporting PL/SQL and PL/pgSQL procedures.</description>
         <maturity>3</maturity>
 
-        <provides url="acs-kernel" version="5.10.1d13"/>
+        <provides url="acs-kernel" version="5.10.1d14"/>
 
         <callbacks>
         </callbacks>
Index: openacs-4/packages/acs-kernel/sql/postgresql/groups-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/groups-create.sql,v
diff -u -N -r1.29.2.3 -r1.29.2.4
--- openacs-4/packages/acs-kernel/sql/postgresql/groups-create.sql	22 Jul 2022 17:37:25 -0000	1.29.2.3
+++ openacs-4/packages/acs-kernel/sql/postgresql/groups-create.sql	1 Dec 2022 16:39:48 -0000	1.29.2.4
@@ -36,6 +36,12 @@
                                               'banned', 'rejected', 'deleted', 'expired'))
 );
 
+--
+-- Create a partial index for a very common case.
+--
+CREATE INDEX membership_rels_rel_id_approved_idx ON membership_rels(rel_id) WHERE member_state = 'approved';
+
+
 create table admin_rels (
         rel_id          integer constraint admin_rels_rel_id_fk
                         references membership_rels (rel_id)
Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.10.1d13-5.10.1d14.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.10.1d13-5.10.1d14.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.10.1d13-5.10.1d14.sql	1 Dec 2022 16:39:48 -0000	1.1.2.1
@@ -0,0 +1,5 @@
+--
+-- Create a partial index for a very common case.
+--
+CREATE INDEX CONCURRENTLY IF NOT EXISTS
+membership_rels_rel_id_approved_idx ON membership_rels(rel_id) WHERE member_state = 'approved';