DROP AGGREGATING INDEX

Deletes an existing aggregating index. Please note that deleting an aggregating index does NOT remove the associated storage blocks. To delete the blocks as well, use the VACUUM TABLE command. To disable the aggregating indexing feature, set enable_aggregating_index_scan to 0.

Syntax

DROP AGGREGATING INDEX <index_name>

Examples

This example deleted an aggregating index named my_agg_index:

DROP AGGREGATING INDEX my_agg_index;