Install on Ubuntu/Debian

Installation on Ubuntu 18.04, Ubuntu 20.04, or Debian 10.

The CPU architecture must be x86-64. The preffered microarchitecture is Intel Skylake.
  1. Tune your operating system for optimal performance.
  2. Install PostgreSQL
    PostgreSQL version 12.7 or 13.3 installed, see .
    Note: To find and install a specific minor version of PostgreSQL do the following:
    sudo sh -c 'echo "deb $(lsb_release -cs)-pgdg-archive main" > /etc/apt/sources.list.d/pgdg.list'
    sudo apt-get update
    sudo apt-cache madison <package name>
    sudo apt-get install <package name>-<version info>
  3. Install the Swarm64 DA repository:
    curl -s | sudo bash
  4. Install the corresponding Swarm64 DA package for your PostgreSQL installation.
    PostgreSQL 12
    sudo apt install swarm64da-psql-12
    PostgreSQL 13
    sudo apt install swarm64da-psql-13
  5. Add swarm64da to shared_preload_libraries in your postgresql.conf configuration file.
    For example:
    shared_preload_libraries = 'swarm64da'
    For other recommended settings see also Recommended PostgreSQL settings.
  6. Restart PostgreSQL.
  7. Switch to a user with access to the database:
    sudo su - postgres
  8. Connect to the database:
  9. Load the Swarm64 DA extension:
    CREATE EXTENSION swarm64da;

    A NOTICE is printed when executing the first SQL command through a connection to a database for which the swarm64da extension 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 on.

  10. Verify that the Swarm64 DA extension is loaded correctly and look up its version number:
    SELECT * FROM swarm64da.get_version();
  11. Install a valid license.
    SELECT swarm64da.load_license('<path-to-license-file-on-server>');
    See also Install a license for Swarm64 DA.
  12. Check and follow the Swarm64 DA settings advisor and documented recommendations to tune your database system for optimal performance.
    SELECT * FROM swarm64da.show_advice();
    See also Settings advisor and Recommended PostgreSQL settings.
  13. 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.