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 lets you maintain very large numbers of connections to a database while minimizing the consumption of server resources.
Access PgBouncer statistics
PgBouncer is used at Aiven as a connection pooler to lower the performance impact of opening new connections to Aiven for PostgreSQL®.
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
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.
Identify PostgreSQL® slow queries
Use the PostgreSQL® pgstatstatements extension to find slow queries.
Detect and terminate long-running queries
Aiven does not terminate any customer queries even if they run
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