Index: openacs-4/packages/logger/sql/postgresql/logger-tables-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/logger/sql/postgresql/logger-tables-create.sql,v
diff -u -r1.5 -r1.5.8.1
--- openacs-4/packages/logger/sql/postgresql/logger-tables-create.sql	9 May 2003 11:04:13 -0000	1.5
+++ openacs-4/packages/logger/sql/postgresql/logger-tables-create.sql	27 Jun 2005 20:38:10 -0000	1.5.8.1
@@ -250,3 +250,15 @@
 end;' language 'plpgsql';
 select inline_0 ();
 drop function inline_0 ();
+
+-- create indexes
+
+CREATE INDEX logger_variables_package_id_inx ON logger_variables(package_id);
+CREATE INDEX logger_projects_inx ON logger_projects(project_lead);
+CREATE INDEX logger_projections_variable_id_inx ON logger_projections(variable_id);
+CREATE INDEX logger_projections_project_id_inx ON logger_projections(project_id);
+CREATE INDEX logger_project_var_map_variable_id_inx ON logger_project_var_map(variable_id);
+CREATE INDEX logger_project_pkg_map_package_id_inx ON logger_project_pkg_map(package_id);
+CREATE INDEX logger_entries_variable_id_inx ON logger_entries(variable_id);
+CREATE INDEX logger_entries_project_id_inx ON logger_entries(project_id);
+CREATE INDEX logger_entries_time_stamp_inx ON logger_entries(time_stamp);