Database administration tasks

Create additional PostgreSQL® databases

Once you've created your Aiven for PostgreSQL® service, you can add

PostgreSQL® in-place upgrades allows to upgrade an instances to a new

Aiven for PostgreSQL® allows a series of pre-approved extensions to be

Aiven provides

Aiven for PostgreSQL® databases are automatically backed up and can be

When an Aiven for PostgreSQL® instance is created, the public schema

Connection Pooling allows you to maintain very large numbers of

PgBouncer is used at Aiven for connection pooling.

Integrate PgBouncer with Datadog to track connection pool metrics and monitor application traffic on the Datadog platform.

dblink is a [PostgreSQL®

pg_repack is a PostgreSQL® extension that allows you to efficiently

pg_cron is a simple cron-based job scheduler for PostgreSQL (10 or

PostgreSQL® 11 introduces a new component in the execution engine, a

PostgreSQL® allows you to keep track of queries with certain performance

Aiven does not terminate any customer queries even if they run

Optimize slow queries to ensure maximum service performance. Use Aiven's AI capabilities or pgstatstatements to identify optimization opportunities.

The PostgreSQL® transaction control mechanism assigns a transaction ID

If your Aiven for PostgreSQL® service runs out of disk space, the

This article provides step-by-step instructions on enabling, using, and

PostgreSQL® offers different commands and functions to get disk space

You can restrict access to Aiven for PostgreSQL® databases and tables by