Deleting Instances Takes a Very Long Time - Recommendation

[bsislow]

Deleting an instance was taking a very long time. I reviewed foreign keys and came up with these recommendations to speed up the dependent removals. I recommend these for a future release.

CREATE INDEX CONCURRENTLY ON statements.statements_history (agent_address, agent_port, queryid, dbid, userid);
CREATE INDEX CONCURRENTLY ON statements.statements_history_current (agent_address, agent_port, queryid, dbid, userid);
CREATE INDEX CONCURRENTLY ON statements.statements_history_current_db (agent_address, agent_port);
CREATE INDEX CONCURRENTLY ON statements.statements_history_db (agent_address, agent_port);

[bersace]

Thanks @bsislow !