# Database Configuration

Some database configuration parameters are automatically tuned for optimal performance.

## PostgreSQL

> [!NOTE]
>
> **Info**
>
> Available RAM has [reserved memory](<https://documentation.syseleven.de/en/products/dbaas/concepts/common-questions/#are-all-resources-cpuram-of-the-flavor-available-to-the-database>) taken into account.

We reserve 1.5 CPU and 1.5 GB memory on each node for system management software.

| Parameter | Value |
| :--- | :--- |
| effective\_cache\_size | 75% of available RAM |
| maintenance\_work\_mem | 1/16 of `shared_buffers` |
| shared\_buffers | 25% of available RAM |
| work\_mem | Available RAM divided by `max_connections` (hardcoded to 100) |
