Postgresql benchmark

https://severalnines.com/blog/benchmarking-postgresql-performance

Command

pgbench -i -p 5432 -d defaultdb -U admin
pgbench -p 5432 -d defaultdb -U admin -c 10
pgbench -p 5432 -d defaultdb -U admin -c 50 -T 60 -S -n
nano /tmp/bench.sql
CREATE TABLE IF NOT EXISTS test_bench (id int8, data varchar);
INSERT INTO test_bench VALUES(1,'test');
INSERT INTO test_bench VALUES(1,'test');
SELECT * FROM test_bench WHERE id=1;
SELECT * FROM test_bench WHERE id=2;


pgbench -p 5432 -d defaultdb -U admin -c 50 -T 60 -S -n -f /tmp/bench.sql

Preparing

Benchmark with 10 clients

Benchmark with 50 clients in 60s