Enable compression on continuous aggregates

You can enable and disable compression on continuous aggregates by setting the compress parameter when you alter the view.

Enabling and disabling compression on continuous aggregates

1. For an existing continuous aggregate, at the psql prompt, enable compression:

2. Disable compression:

Disabling compression on a continuous aggregate fails if there are compressed chunks associated with the continuous aggregate. In this case, you need to decompress the chunks, and then drop any compression policy on the continuous aggregate, before you disable compression. For more detailed information, see the [decompress chunks][decompress-chunks] section: