Migrate a continuous aggregate to the new form

URL: llms-txt#migrate-a-continuous-aggregate-to-the-new-form

Contents:

• Configure continuous aggregate migration
• Check on continuous aggregate migration status
• Troubleshooting
  • Permissions error when migrating a continuous aggregate

In TimescaleDB v2.7 and later, continuous aggregates use a new format that improves performance and makes them compatible with more SQL queries. Continuous aggregates created in older versions of TimescaleDB, or created in a new version with the option timescaledb.finalized set to false, use the old format.

To migrate a continuous aggregate from the old format to the new format, you can use this procedure. It automatically copies over your data and policies. You can continue to use the continuous aggregate while the migration is happening.

Connect to your database and run:

There are known issues with cagg_migrate() in version 2.8.0. Upgrade to version 2.8.1 or later before using it.