PostgreSQL optimization pack
The PostgreSQL optimization pack allows you to explore and tune the configuration space of PostgreSQL parameters. In this way, an Akamas study can ramp up the transaction number or minimize its resource consumption according to your typical workload, cutting costs. The main tuning areas covered by the parameters provided in this optimization pack are:
Background writer management
VACUUM management
Deadlock and concurrency management
Write-ahead management
The optimization pack includes metrics to monitor:
Query executions
Concurrency and locks
Buffers and disk I/O
Component Types
These component types model different PostgreSQL releases. They provided a subset of the parameters available for the best optimization results.
PostgeSQL 11
PostgeSQL 12
Installing
Here’s the command to install the PostgreSQL optimization pack using the Akamas CLI:
Last updated