Manage the Aiven for AlloyDB Omni columnar engine

Enable or disable the Aiven for AlloyDB Omni columnar engine, and control how much RAM it can use to leverage AI and analytics capabilities of your service.

The Aiven for AlloyDB Omni columnar engine accelerates SQL query processing of scans, joins, and aggregates using Google's AlloyDB Omni columnar engine.

important

Any change to columnar engine settings results in restarting the service.

Prerequisites

• Aiven for AlloyDB Omni service running
• Access to one of the following tools:
  • Aiven Console
  • Aiven Provider for Terraform
  • Aiven Operator for Kubernetes®

Enable the columnar engine

note

The columnar engine is enabled by default.

Console

1. Log in to the Aiven Console.
2. On the Services page, select a service.
3. Click Service settings, and go to Columnar engine.
4. Click Configure.
5. Set google_columnar_engine_enabled to Enabled.
6. Click Save configuration.

Terraform

Update the aiven_alloydbomni resource: in the alloydbomni_user_config block, set attribute google_columnar_engine_enabled to true.

Kubernetes

Update the AlloyDBOmni resource: in the userConfig block nested in spec, set option google_columnar_engine_enabled to true.

Configure the size of the columnar data store

By default, the columnar engine is set to use up to 10% of your service's RAM. You can modify the size of the columnar engine memory to a maximum of 50% of the service's memory.

Console

1. Log in to the Aiven Console.
2. On the Services page, select a service.
3. Click Service settings, and go to Columnar engine.
4. Click Configure.
5. Set google_columnar_engine_memory_size_percentage to a value between 0 and 50.
6. Click Save configuration.

Terraform

Update the aiven_alloydbomni resource: in the alloydbomni_user_config block, set attribute google_columnar_engine_memory_size_percentage to a value between 0 and 50.

Kubernetes

Update the AlloyDBOmni resource: in the userConfig block nested in spec, set option google_columnar_engine_memory_size_percentage to a value between 0 and 50.

Disable the columnar engine

Disable the columnar engine if its design doesn't align well with your workloads or system requirements. Disabling the columnar engine releases resources allocated for the columnar engine.

Console

1. Log in to the Aiven Console.
2. On the Services page, select a service.
3. Click Service settings, and go to Columnar engine.
4. Click Configure.
5. Set google_columnar_engine_enabled to Disabled.
6. Click Save configuration.

Terraform

Update the aiven_alloydbomni resource: in the alloydbomni_user_config block, set attribute google_columnar_engine_enabled to false.

Kubernetes

Update the AlloyDBOmni resource: in the userConfig block nested in spec, set option google_columnar_engine_enabled to false.