pg bench and timescale db

pgbench

L
9.5.10
listen_addresses = 'localhost'          
listen_addresses = '*'          

max_connections = 100
max_connections = 200

shared_buffers = 128MB  
shared_buffers = 16GB


effective_cache_size = 4GB
effective_cache_size = 48GB

default_statistics_target = 100

min_wal_size = 1GB
max_wal_size = 2GB
checkpoint_completion_target = 0.7
wal_buffers = 16MB

maintenance_work_mem = 16MB
maintenance_work_mem = 2GB

work_mem = 1MB
work_mem = 83886kB

random_page_cost = 1.1

create database bench;
create database bench1;
create database bench2;
create database bench3;

create database bench owner cj;
create database bench1 owner cj;
create database bench2 owner cj;
create database bench3 owner cj;

pgbench -i performance_test 

pgbench -i performance_test -t 10000000
pgbench -i performance_test -T 180 -P 1


pgbench -i -s 15 bench1
pgbench -c 4 -j 2 -T 600 bench1 

pgbench -i -s 70 bench2
pgbench -c 4 -j 2 -T 600 bench2 -P 5
pgbench -c 4 -j 2 -T 600 -S bench2 -P 10
pgbench -c 4 -j 2 -T 600 -N bench2 -P 10


pgbench -i -s 600 bench3
pgbench -c 4 -j 2 -T 600 bench3 -P 10


pgbench -i -s 30 bench
pgbench -c 1 -T 600 bench
pgbench -c 8 -j 2 -T 600 bench
pgbench -c 64 -j 4 -T 600 bench
pgbench -c 64 -j 4 -T 600 -N bench

#batch

pgbench -i -s 15 bench1; pgbench -i -s 70 bench2; pgbench -i -s 600 bench3; pgbench -i -s 30 bench




sudo apt-get update
sudo apt-get install postgresql-9.6
sudo apt-get --purge remove postgresql
sudo add-apt-repository ppa:timescale/timescaledb-ppa
sudo apt-get update
sudo apt install timescaledb
CREATE USER cj WITH PASSWORD 'password' CREATEDB;


#ubuntu 
sudo apt-get install libblas-dev liblapack-dev
sudo apt-get install libopencv-highgui-dev


cargo install cargo-update -v.