How-To Guides
Creating a Database
ClickHouse is a high-performance columnar database designed for real-time analytical processing. ...
Upgrading to Major Version
Upgrading a database service on Elestio can be done without creating a new instance or performing...
Installing and Updating an Extension
ClickHouse supports custom extensions via [User Defined Functions (UDFs)], external dictionaries,...
Creating Manual Backups
Regular backups are essential when running a ClickHouse deployment, especially if you’re using it...
Restoring a Backup
Restoring ClickHouse backups is essential for disaster recovery, staging environment duplication,...
Identifying Slow Queries
Slow queries can impact ClickHouse performance, especially under high load or with inefficient qu...
Detect and terminate long-running queries
ClickHouse is a high-performance, column-oriented OLAP database, but poorly optimized or long-run...
Preventing Full Disk Issues
Running out of disk space in a ClickHouse environment can cause query failures, part merge errors...
Checking Database Size and Related Issues
As your ClickHouse data grows especially with large analytical workloads or high-ingestion pipeli...