Skip to main content
Migrate a from the old format to the new format introduced in 2.7. 
CALL cagg_migrate (
    cagg REGCLASS,
    override BOOLEAN DEFAULT FALSE,
    drop_old BOOLEAN DEFAULT FALSE
);
2.7 introduced a new format for s that improves performance. It also makes s compatible with more types of SQL queries. The new format, also called the finalized format, stores the data exactly as it appears in the final view. The old format, also called the partial format, stores the data in a partially aggregated state. Use this procedure to migrate s from the old format to the new format. For more information, see the migration how-to guide.
There are known issues with cagg_migrate() in version 2.8.0. Upgrade to version 2.8.1 or above before using it.

​
Arguments

The syntax is: 
CALL cagg_migrate(
    cagg = '<view_name>',
    override = true | false,
    drop_old = true | false
);
NameTypeDefaultRequiredDescription
caggREGCLASS-✔The to migrate
overrideBOOLEANfalse-If false, the old keeps its name. The new is named <OLD_CONTINUOUS_AGGREGATE_NAME>_new. If true, the new gets the old name. The old is renamed <OLD_CONTINUOUS_AGGREGATE_NAME>_old.
drop_oldBOOLEANfalse-If true, the old is deleted. Must be used together with override.