drop index btime 
;
drop index bfreq
;
drop index bname
;
drop index pylanduse
;
drop index pointloc
;
drop index pyloc
;
drop index islandloc
;
begin transaction;

create index btime on rasters using btree (rtime integer_ops)
;
create index bfreq on rasters using btree (frequency integer_ops)
;
create index bname on points using btree (name text_ops)
;
create index pylanduse on polygons using btree (landuse integer_ops)
;
create index pointloc on points using rtree (pt_make_poly(location) Poly_ops)
;
create index pyloc on polygons using rtree (location Poly_ops)
;
create index islandloc on islands using rtree (location Poly_ops) 
;
end transaction;

vacuum with (statistics);
