cookbooks/db/files/default/yearly-reindex.sql

   1 REINDEX (VERBOSE) TABLE CONCURRENTLY current_node_tags;
   2 REINDEX (VERBOSE) TABLE CONCURRENTLY current_nodes;
   3 REINDEX (VERBOSE) TABLE CONCURRENTLY current_relation_tags;
   4 REINDEX (VERBOSE) TABLE CONCURRENTLY current_relations;
   5 REINDEX (VERBOSE) TABLE CONCURRENTLY current_way_nodes;
   6 REINDEX (VERBOSE) TABLE CONCURRENTLY current_way_tags;
   7 REINDEX (VERBOSE) TABLE CONCURRENTLY current_ways;
   8 REINDEX (VERBOSE) TABLE CONCURRENTLY gps_points;
   9 REINDEX (VERBOSE) TABLE CONCURRENTLY node_tags;
  10 REINDEX (VERBOSE) TABLE CONCURRENTLY nodes;
  11 REINDEX (VERBOSE) TABLE CONCURRENTLY relation_members;
  12 REINDEX (VERBOSE) TABLE CONCURRENTLY relation_tags;
  13 REINDEX (VERBOSE) TABLE CONCURRENTLY relations;
  14 REINDEX (VERBOSE) TABLE CONCURRENTLY way_nodes;
  15 REINDEX (VERBOSE) TABLE CONCURRENTLY way_tags;
  16 REINDEX (VERBOSE) TABLE CONCURRENTLY ways;