ALTER DATABASE statement
FeatureBase Serverless databases allow you to scale your database RAM and CPU resources when required and without needing to spin the database down.
Cloud Serverless databases can be modified using the ALTER DATABASE statement.
FeatureBase Serverless databases are in Cloud Preview with limited functionality and are not suitable for production systems.
Syntax
ALTER DATABASE database-name WITH WORKERS <int-val>;
Arguments
| Argument | Description | Required | Default | Additional information |
|---|---|---|---|---|
database-name | Name of database | Yes | Database names cannot be altered | |
WITH WORKERS <int-val> | Add an integer value for each worker which represents 2GB of memory and 1x vCPU | Yes | 1 | 0 to 8 workers can be set with a maximum of 16GB of memory and 8vCPU |
Examples
Set a serverless database with 6GB of memory and 3 vCPU processors.
ALTER DATABASE my-db WITH WORKERS 3;