Index: openacs-4/packages/calendar/sql/postgresql/calendar-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/sql/postgresql/calendar-create.sql,v diff -u -N -r1.20.2.1 -r1.20.2.2 --- openacs-4/packages/calendar/sql/postgresql/calendar-create.sql 9 Aug 2019 20:34:07 -0000 1.20.2.1 +++ openacs-4/packages/calendar/sql/postgresql/calendar-create.sql 11 Dec 2020 18:42:37 -0000 1.20.2.2 @@ -194,7 +194,11 @@ keep track of package instances '; +-- create a partial index on public calendars +create index calendars_package_id_pidx on calendars(package_id) where private_p = false; + + -- Calendar Item Types create sequence cal_item_type_seq;