Index: openacs-4/packages/news-aggregator/sql/postgresql/upgrade/upgrade-0.9.6b-0.9.7.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/news-aggregator/sql/postgresql/upgrade/Attic/upgrade-0.9.6b-0.9.7.sql,v diff -u -N --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/news-aggregator/sql/postgresql/upgrade/upgrade-0.9.6b-0.9.7.sql 4 Jan 2006 16:48:04 -0000 1.1.2.1 @@ -0,0 +1,4 @@ +# Create a few indexes to speed up index page query +create index na_saved_items_aggregator_id_idx on na_saved_items(aggregator_id); +create index na_purges_aggregator_id_idx on na_purges(aggregator_id); +create index na_aggregators_package_id_idx on na_aggregators(package_id);