Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql,v
diff -u -N -r1.60.2.1 -r1.60.2.2
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql	16 Sep 2013 09:49:28 -0000	1.60.2.1
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql	25 Dec 2013 16:10:31 -0000	1.60.2.2
@@ -494,6 +494,7 @@
 -- create index cr_revisions_lower_title_idx on cr_revisions(lower(title));
 -- create index cr_revisions_title_ltr_idx on cr_revisions(substr(lower(title), 1, 1));
 
+create index cr_revisions_content_idx on cr_revisions (substring(content for 100));
 
 comment on table cr_revisions is '
   Each content item may be associated with any number of revisions.