Download and try Vitesse DB for 30 days.

VersionBuildBlock SizeLink
9.5.3 Standard1608148kvitessedb.9.5.3.S.rh6.x86_64.160814.bin
9.4.7 Standard1604078kvitessedb.9.4.7.S.rh6.x86_64.160407.bin
9.3.11 Enterprise16042632kvitessedb.9.3.11.E.rh6.x86_64.32k.160426.bin
9.3.11 Enterprise1604268kvitessedb.9.3.11.E.rh6.x86_64.160426.bin
VersionBuildBlock SizeLink
9.5.3 Standard1608148kvitessedb.9.5.3.S.ubuntu14.x86_64.160814.bin
9.4.7 Standard1604078kvitessedb.9.4.7.S.ubuntu14.x86_64.160407.bin
9.3.11 Enterprise16042632kvitessedb.9.3.11.E.ubuntu14.x86_64.32k.160426.bin
9.3.11 Enterprise1604268kvitessedb.9.3.11.E.ubuntu14.x86_64.160426.bin


Install

The file you downloaded is a .bin file that can be executed directly with bash.

Execute the .bin script to install Vitesse DB:

% bash THE-BIN-FILE-YOU-DOWNLOADED

The installation script will install the database binary in the current directory, and create a simple symlink vitessedb to point to it.



Simple Test

To verify that the installation was successful, we will create an instance and start the service.

% # Source the env
% source vitessedb/env.sh

% # Create test dir
% mkdir mytest

% # Initialize and start Vitesse DB server
% initdb -D mytest/data
% postgres -D mytest/data > mytest/logfile 2>&1 &

% # Create test database and connect to it in psql
% createdb test
% psql test

At this point, we have connected to the test database via psql. Let's load some data and run some queries.

test=# -- show the version string
test=# show vitesse.version;

test=# -- create a table t with 1 million bigints
test=# create table t as
    select generate_series(1,1000000)::bigint as i;

test=# -- turn on timing
test=# \timing on

test=# -- Disable Vitesse and run some queries. Note the timing.
test=# set vitesse.enable = 0;
test=# select * from t where i = 10 or i = 20 or i = 30;
test=# select count(*), sum(i*i), avg(i) from t;

test=# -- Enable Vitesse and run the same queries. Note the timing.
test=# set vitesse.enable = 1;
test=# select * from t where i = 10 or i = 20 or i = 30;
test=# select count(*), sum(i*i), avg(i) from t;

test=# -- Compare the timings
test=#

You should be able to see some big speedup in those two queries when Vitesse was enabled.