Global out of space on /mnt/store2 that has all the index files

If /mnt/store2 runs out of space, you will see "out of space" messages in syslog and may get an error trying to save changes.

This should be escalated to Fred, but he likes to see what he did the last time.

df -h

global=> SELECT
schemaname,
indexname,
tablename,
pg_size_pretty(pg_total_relation_size(schemaname || '.' || indexname)) AS index_size
FROM
pg_indexes
ORDER BY
pg_total_relation_size(schemaname || '.' || indexname) DESC
LIMIT 10;
schemaname | indexname | tablename | index_size
-------------+-----------------------------------------+---------------------------+------------
replication | netbox_replication_rows_by_netbox_ak | netbox_replication_rows | 33 GB
history | activity_by_netbox_global_ak | activity | 20 GB
replication | stage_object_map_pk | stage_object_map | 14 GB
replication | stage_activity_object_map_pk | stage_activity_object_map | 14 GB
history | activity_pk | activity | 11 GB
history | activity_by_access_card_ak | activity | 6863 MB
history | activity_by_person_ak | activity | 6794 MB
replication | netbox_replication_rows_by_state_ak | netbox_replication_rows | 3344 MB
replication | netbox_replication_rows_by_nbid_rrid_ak | netbox_replication_rows | 1839 MB
history | other_activity_pk | other_activity | 1800 MB
(10 rows)

stop global daemons

global=> DROP INDEX replication.netbox_replication_rows_by_netbox_ak;
DROP INDEX
global=> CREATE INDEX netbox_replication_rows_by_netbox_ak ON replication.netbox_replication_rows(netbox_id) TABLESPACE replication_idx;
CREATE INDEX
global=> DROP INDEX replication.stage_activity_object_by_source_ak;
DROP INDEX
CREATE UNIQUE INDEX stage_activity_object_by_source_ak ON replication.stage_activity_object_map(hist_source_id, stage_table_lookup_id, stage_object_serial_id)
TABLESPACE replication_idx;
CREATE INDEX

df -h