ALTER MATERIALIZED VIEW RESUME WAL

info

Materialized View support is now generally available (GA) and ready for production use.

If you are using versions earlier than 8.3.1, we suggest you upgrade at your earliest convenience.

ALTER MATERIALIZED VIEW RESUME WAL restarts WAL table transactions after resolving errors.

Accepts the same optional sequencerTxn input as the ALTER TABLE RESUME WAL operation. Refer to that page for more details.

Syntax​

Flow chart showing the syntax of the ALTER MATERIALIZED VIEW keyword

Flow chart showing the syntax of ALTER MATERIALIZED VIEW with RESUME WAL keyword

Example​

Use the wal_tables() function to investigate the materialized view status:

List all tables and materialized viewsDemo this query
wal_tables();
namesuspendedwriterTxnsequencerTxn
trades_1htrue35

The trades_1h view is suspended. The last successful commit is 3.

The following query restarts transactions from the failed transaction, 4:

ALTER MATERIALIZED VIEW trades_1h RESUME WAL;

See also​

For more information on the concept, see the reference on materialized views.