Latest News
Start your free PG Nitrous Trial Get started ›
Come play in the new interactive Swarm64 DA query sandbox start here ›
Unleash PostgreSQL Parallel Query Read more ›

How to run Swarm64 DA with EDB Postgres Advanced Server

Posted in How to, PostgreSQL, Video

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: 

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.