Download and try Vitesse DB for 30 days.
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.
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.