In this 5-minute video you will learn how to install a free development license of the EDB-certified Swarm64 DA extension into an EDB Postgres Advanced Server to accelerate query performance:
Here are the steps I follow in the video:
- Get a free development license
- Download and install the Swarm64 DA package for on EDB Postgres Advanced Server (Ubuntu package / Centos package)
- Get and install your Swarm64 DA license key
- Create a columnstore index on tables that will be accessed by analytic queries
After installing Swarm64 DA, I demonstrate how Swarm64 DA and columnstore indexes speed up TPC-H query by 5x. For your convenience, here are some of the SQL commands I used in the demo:
Loading a License File Using PSQL Client
SELECT swarm64da.load_license('<path-to-license-file-on-server>');
Create Columnstore Index Syntax
CREATE INDEX index_name ON table USING columnstore ( col1, col2, col3, col4, col5 );
Server Details
- AWS EC2 r5.8xlarge
- 32 vCPUs
- 256gb RAMUbuntu 20.04.2.0 LTS
- EDB Advanced Server version 13
Postgresql.conf Tuning
max_connections = 20
shared_buffers = 64GB
effective_cache_size = 192GB
maintenance_work_mem = 2GB
checkpoint_completion_target = 0.9
wal_buffers = 16MB
default_statistics_target = 100
random_page_cost = 1.1
effective_io_concurrency = 200
work_mem = 419430kB
min_wal_size = 1GB
max_wal_size = 4GB
max_worker_processes = 32
max_parallel_workers_per_gather = 4
max_parallel_workers = 32
max_parallel_maintenance_workers = 4
Try Swarm64 DA with EDB Postgres Advanced
Download Swarm64 DA for free and install it as an extension to EDB Postgres Advanced versions 12 and 13. Check our documentation for more information and subscribe to our monthly newsletter to get the latest news about high-performing PostgreSQL. For licensing and support of EDB Postgres Advanced, go to the EDB plans page.