How-To Guides
Creating a Database
PostgreSQL allows you to create databases using different methods, including the PostgreSQL inter...
Upgrading to a Major Version
Upgrading a database service on Elestio can be done without creating a new instance or performing...
Installing or Updating an Extension
PostgreSQL supports a wide range of extensions that add extra functionality to the core database ...
Creating Manual Backups
Regular backups are a key part of managing a PostgreSQL deployment. While Elestio provides automa...
Restoring a Backup
Restoring backups is essential for recovery, environment duplication, or rollback scenarios. Eles...
Identifying Slow Queries
Slow queries can significantly affect application performance and user experience. PostgreSQL off...
Detect and terminate long-running queries
Long-running queries can significantly impact database performance by consuming CPU, memory, and ...
Preventing Full Disk Issues
Running out of disk space in a database environment can lead to failed writes, service downtime, ...
Checking Database Size and Related Issues
As your PostgreSQL database grows over time, it’s important to monitor its size and identify what...