# HG changeset patch
# User Paul Boddie <paul@boddie.org.uk>
# Date 1460248367 -7200
# Node ID e97c3208d57ef2c6fb01d2d043f0516fd6326a58
# Parent  bfa410ae3d635c855b7c36c6449f4d9b40522885
Added tentative indexes.

diff -r bfa410ae3d63 -r e97c3208d57e conf/postgresql/schema.sql
--- a/conf/postgresql/schema.sql	Sun Apr 03 23:21:31 2016 +0200
+++ b/conf/postgresql/schema.sql	Sun Apr 10 02:32:47 2016 +0200
@@ -48,6 +48,9 @@
     expires varchar
 );
 
+create index freebusy_start on freebusy(store_user, "start");
+create index freebusy_end on freebusy(store_user, "end");
+
 create table freebusy_offers (
     store_user varchar not null,
     "start" varchar not null,
@@ -60,6 +63,9 @@
     expires varchar
 );
 
+create index freebusy_offers_start on freebusy_offers(store_user, "start");
+create index freebusy_offers_end on freebusy_offers(store_user, "end");
+
 create table freebusy_other (
     store_user varchar not null,
     other varchar not null,
@@ -73,17 +79,24 @@
     expires varchar
 );
 
+create index freebusy_other_start on freebusy_other(store_user, other, "start");
+create index freebusy_other_end on freebusy_other(store_user, other, "end");
+
 create table freebusy_providers (
     store_user varchar not null,
     object_uid varchar not null,
     object_recurrenceid varchar
 );
 
+create index freebusy_providers_store_user on freebusy_providers(store_user);
+
 create table freebusy_provider_datetimes (
     store_user varchar not null,
     "start" varchar
 );
 
+create index freebusy_provider_datetimes_store_user on freebusy_provider_datetimes(store_user);
+
 -- Object store request details.
 
 create table requests (
@@ -93,6 +106,8 @@
     request_type varchar
 );
 
+create index requests_object_uid on requests(store_user, object_uid);
+
 
 
 -- Journal store tables.
@@ -112,6 +127,9 @@
     expires varchar
 );
 
+create index quota_freebusy_start on quota_freebusy(quota, user_group, "start");
+create index quota_freebusy_end on quota_freebusy(quota, user_group, "end");
+
 create table user_freebusy (
     quota varchar not null,
     store_user varchar not null,
@@ -125,6 +143,9 @@
     expires varchar
 );
 
+create index user_freebusy_start on user_freebusy(quota, store_user, "start");
+create index user_freebusy_end on user_freebusy(quota, store_user, "end");
+
 -- Journal user groups and limits.
 
 create table quota_limits (