#!/bin/bash

DBNAME=$1

while read layer; do
    table=${layer%%@*}
    echo $table
    echo "create index ${table}_geom_idx on $table using gist (wkb_geometry gist_geometry_ops);" | psql $DBNAME
done

echo "vacuum analyze" | psql $DBNAME