Install on Ubuntu/Debian
Installation on Ubuntu 18.04, Ubuntu 20.04, or Debian 10.
- Tune your operating system for optimal performance.
EPAS version 12.6 or 13.2 installed, see https://www.enterprisedb.com/downloads/edb-postgres-advanced-server.
Install the Swarm64 DA repository:
curl -s https://packagecloud.io/install/repositories/swarm64/swarm64da/script.deb.sh | sudo bash
Install the corresponding Swarm64 DA package for your EPAS installation.
- EPAS 12
sudo apt install swarm64da-epas-12
- EPAS 13
sudo apt install swarm64da-epas-13
shared_preload_librariesin your postgresql.conf configuration file.For example:
For other recommended settings see also Recommended EPAS settings.
shared_preload_libraries = 'swarm64da'
- Restart EPAS.
Switch to a user with access to the database:
sudo su - enterprisedb
Connect to the database:
edb-psql -d postgres
Load the Swarm64 DA extension:
CREATE EXTENSION swarm64da;
NOTICEis printed when executing the first SQL command through a connection to a database for which the
swarm64daextension has not been created yet. This behavior is controlled by the following configuration parameter:
- swarm64da.enable_notice_not_created_extension (boolean)
Enables or disables the reminder to create the extension. The default is
Verify that the Swarm64 DA extension is loaded correctly and look up its
SELECT * FROM swarm64da.get_version();
Install a valid license.
See also Install a license for Swarm64 DA.
- Check and follow the Swarm64 DA settings advisor and documented recommendations to tune your database system for optimal performance.
Create columnstore indexes.
Columnstore indexes are necessary to maximize the performance benefits. Create an index for each large table covering the most common accessed columns. See Columnstore index and Using a columnstore index on a small TPC-H data set.