Database administration tasks
Create additional PostgreSQL® databases
Once you've created your Aiven for PostgreSQL® service, you can add
Perform a PostgreSQL® major version upgrade
PostgreSQL® in-place upgrades allows to upgrade an instances to a new
Install or update an extension
Aiven for PostgreSQL® allows a series of pre-approved extensions to be
Create manual PostgreSQL® backups
Aiven provides
Restore PostgreSQL® from a backup
Aiven for PostgreSQL® databases are automatically backed up and can be
Claim public schema ownership
When an Aiven for PostgreSQL® instance is created, the public schema
Manage connection pooling
Connection Pooling allows you to maintain very large numbers of
Access PgBouncer statistics
PgBouncer is used at Aiven for connection pooling.
Monitor PgBouncer in Datadog
Integrate PgBouncer with Datadog to track connection pool metrics and monitor application traffic on the Datadog platform.
Use the PostgreSQL® dblink extension
dblink is a [PostgreSQL®
Use the PostgreSQL® pg_repack extension
pg_repack is a PostgreSQL® extension that allows you to efficiently
Use the PostgreSQL® pg_cron extension
pg_cron is a simple cron-based job scheduler for PostgreSQL (10 or
Enable JIT in PostgreSQL®
PostgreSQL® 11 introduces a new component in the execution engine, a
Identify PostgreSQL® slow queries
PostgreSQL® allows you to keep track of queries with certain performance
Detect and terminate long-running queries
Aiven does not terminate any customer queries even if they run
Optimize Aiven for PostgreSQL® slow queries
Optimize slow queries to ensure maximum service performance. Use Aiven's AI capabilities or pgstatstatements to identify optimization opportunities.
Check and avoid transaction ID wraparound
The PostgreSQL® transaction control mechanism assigns a transaction ID
Prevent PostgreSQL® full disk issues
If your Aiven for PostgreSQL® service runs out of disk space, the
Enable and use pgvector on Aiven for PostgreSQL®
This article provides step-by-step instructions on enabling, using, and
Check size of a database, a table or an index
PostgreSQL® offers different commands and functions to get disk space
Restrict access to databases or tables in Aiven for PostgreSQL®
You can restrict access to Aiven for PostgreSQL® databases and tables by