Disable the columnar engine

Stay organized with collections Save and categorize content based on your preferences.

This page describes how to disable the columnar engine on an AlloyDB instance.

When the query execution metrics show that the columnar engine is underutilized, you can disable it to avoid the overhead of the static-sized column store.

To disable the columnar engine on an instance, set that instance's google_columnar_engine.enabled flag to off. For more information on setting an instance's database flags, see Configure an instance's database flags.

Note that AlloyDB automatically restarts the instance after you update this flag.