Database administration tasks

Create additional PostgreSQL® databases

Perform a PostgreSQL® major version upgrade

Install or update an extension

Create manual PostgreSQL® backups

Restore PostgreSQL® from a backup

Claim public schema ownership

Manage connection pooling

Access PgBouncer statistics

Use the PostgreSQL® dblink extension

Use the PostgreSQL® pg_repack extension

Enable JIT in PostgreSQL®

Identify PostgreSQL® slow queries

Detect and terminate long-running queries

Optimize PostgreSQL® slow queries

Check and avoid transaction ID wraparound

Prevent PostgreSQL® full disk issues

Enable and use pgvector on Aiven for PostgreSQL®

Check size of a database, a table or an index

Restrict access to databases or tables in Aiven for PostgreSQL®”.