Posted On: Aug 25, 2021

Amazon Relational Database Service (Amazon RDS) now supports Boolean DB parameter expressions in PostgreSQL parameter groups, which enables database administrators to optimize more database configurations with fewer parameter groups.

On Amazon RDS, you templatize your database configuration using parameter groups. Many customers choose to change the default Amazon RDS parameter group to better fit their use case. With Boolean DB parameter expressions, you can add conditional deployment configurations based on the properties of a database (DB) instance. For example, compression of the PostgreSQL write ahead log (WAL) can decrease your IO load in exchange for increased CPU load. With Boolean parameter expressions, you can set your parameter group to automatically turn off WAL compression if the CPU of your DB instance is small (e.g., less than or equal to 2 vCPU) but turn it on when the CPU is larger.

Amazon RDS for PostgreSQL makes it easy to set up, operate, and scale PostgreSQL deployments in the cloud. Learn more about parameter groups and Boolean DB parameter expressions in the Amazon RDS User Guide. See Amazon RDS for PostgreSQL Pricing for pricing details.