Тест №1

Решил для статистики замерить некоторые системы.

Диск SSD Samsung EVO 850 PROF

C:\Users\user>wmic memorychip get speed
Speed
1600
1600
1600
1600

"c:\Program Files\PostgreSQL\10.5-24.1C\bin\psql" -U postgres -c "\l"
"c:\Program Files\PostgreSQL\10.5-24.1C\bin\psql" -U postgres  -c "CREATE DATABASE example"
"c:\Program Files\PostgreSQL\10.5-24.1C\bin\pgbench" -U postgres -i -s 500 example
"c:\Program Files\PostgreSQL\10.5-24.1C\bin\psql" -U postgres -d example -c "select pg_size_pretty( pg_database_size('example'))

3 измерения:

"c:\Program Files\PostgreSQL\10.5-24.1C\bin\pgbench" -U postgres  -c 10 -j 10 -t 10000 example
Password:
starting vacuum...end.
transaction type: <builtin: TPC-B (sort of)>
scaling factor: 500
query mode: simple
number of clients: 10
number of threads: 10
number of transactions per client: 10000
number of transactions actually processed: 100000/100000
latency average = 3.040 ms
tps = 3289.390486 (including connections establishing)
tps = 3325.788023 (excluding connections establishing)

"c:\Program Files\PostgreSQL\10.5-24.1C\bin\pgbench" -U postgres  -c 10 -j 10 -t 10000 example
Password:
starting vacuum...end.
transaction type: <builtin: TPC-B (sort of)>
scaling factor: 500
query mode: simple
number of clients: 10
number of threads: 10
number of transactions per client: 10000
number of transactions actually processed: 100000/100000
latency average = 2.910 ms
tps = 3435.981069 (including connections establishing)
tps = 3492.565201 (excluding connections establishing)

"c:\Program Files\PostgreSQL\10.5-24.1C\bin\pgbench" -U postgres  -c 10 -j 10 -t 10000 example
Password:
starting vacuum...end.
transaction type: <builtin: TPC-B (sort of)>
scaling factor: 500
query mode: simple
number of clients: 10
number of threads: 10
number of transactions per client: 10000
number of transactions actually processed: 100000/100000
latency average = 2.891 ms
tps = 3459.557407 (including connections establishing)
tps = 3500.556718 (excluding connections establishing)

с настройкой postgresql.conf и без тж
Заполнить: 240 с
Провести: 190 с


На той же машине virtualbox c ubuntu 16.04

Для Linux:
Настройка PostgreSQL с помощью pgbench
 
Тест  pgbench
$ sudo su postgres
$ psql -l
$ psql -c "CREATE DATABASE example;"
$ pgbench -i -s 500 example
$ psql -U postgres -d example -c "select pg_size_pretty( pg_database_size('example'))"
$ pgbench -c 10 -j 10 -t 10000 example

3 измерения.

postgres@u1604:/home/user$ pgbench -c 10 -j 10 -t 10000 example
starting vacuum...end.
transaction type: <builtin: TPC-B (sort of)>
scaling factor: 500
query mode: simple
number of clients: 10
number of threads: 10
number of transactions per client: 10000
number of transactions actually processed: 100000/100000
latency average = 3.453 ms
tps = 2896.228188 (including connections establishing)
tps = 2898.570111 (excluding connections establishing)

postgres@u1604:/home/user$ pgbench -c 10 -j 10 -t 10000 example
starting vacuum...end.
transaction type: <builtin: TPC-B (sort of)>
scaling factor: 500
query mode: simple
number of clients: 10
number of threads: 10
number of transactions per client: 10000
number of transactions actually processed: 100000/100000
latency average = 4.226 ms
tps = 2366.314628 (including connections establishing)
tps = 2367.762108 (excluding connections establishing)

postgres@u1604:/home/user$ pgbench -c 10 -j 10 -t 10000 example
starting vacuum...end.
transaction type: <builtin: TPC-B (sort of)>
scaling factor: 500
query mode: simple
number of clients: 10
number of threads: 10
number of transactions per client: 10000
number of transactions actually processed: 100000/100000
latency average = 4.197 ms
tps = 2382.378383 (including connections establishing)
tps = 2383.881562 (excluding connections establishing)