# 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.

| Component Type                                                                                                             | Description  |
| -------------------------------------------------------------------------------------------------------------------------- | ------------ |
| [PostgeSQL 11](https://docs.akamas.io/akamas-docs/3.1.3/akamas-reference/optimization-packs/postgresql-pack/postgresql-11) | PostgeSQL 11 |
| [PostgeSQL 12](https://docs.akamas.io/akamas-docs/3.1.3/akamas-reference/optimization-packs/postgresql-pack/postgresql-12) | PostgeSQL 12 |

## Installing

Here’s the command to install the PostgreSQL optimization pack using the Akamas CLI:

```bash
akamas install optimization-pack PostgreSQL
```


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.akamas.io/akamas-docs/3.1.3/akamas-reference/optimization-packs/postgresql-pack.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.