Optimizing PostgreSQL

When optimizing a PostgreSQL instance, typically the goal is one of the following:

• Throughput optimization: increasing the number of transactions

• Cost optimization: minimize resource consumption according to a typical workload, thus cutting costs

Please refer to the PostgreSQL optimization pack for the list of component types, parameters, metrics, and constraints.

Workflow

Applying parameters

Akamas offers many operators that you can use to apply the parameters for the tuned PostgreSQL instances. In particular, we suggest using the FileConfigurator operator for parameters templating and configuration, and the Executor operator for restoring DB data and launching scripts.

A typical optimization process involves the following steps:

1. Configure PostgreSQL parameters

2. Restore DB data

3. Restart PostgreSQL and wait for the initialization

4. Run benchmark

5. Parse results

Please note that most PostgreSQL parameters do not need an application restart.