с fsync = on/usr/pgsql/bin/pgbench -i alex
NOTICE: table "pgbench_branches" does not exist, skipping
NOTICE: table "pgbench_tellers" does not exist, skipping
NOTICE: table "pgbench_accounts" does not exist, skipping
NOTICE: table "pgbench_history" does not exist, skipping
creating tables...
10000 tuples done.
20000 tuples done.
30000 tuples done.
40000 tuples done.
50000 tuples done.
60000 tuples done.
70000 tuples done.
80000 tuples done.
90000 tuples done.
100000 tuples done.
set primary key...
NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "pgbench_branches_pkey" for table "pgbench_branches"
NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "pgbench_tellers_pkey" for table "pgbench_tellers"
NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "pgbench_accounts_pkey" for table "pgbench_accounts"
vacuum...done.
-bash-4.1$ /usr/pgsql/bin/pgbench -c 100 -t 300 alex
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 1
query mode: simple
number of clients: 100
number of threads: 1
number of transactions per client: 300
number of transactions actually processed: 30000/30000
tps = 111.247465 (including connections establishing)
tps = 111.381112 (excluding connections establishing)
Это без райда ......
поставил
synchronous_commit = off
-bash-4.1$ /usr/pgsql/bin/pgbench -c 100 -t 300 alex
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 1
query mode: simple
number of clients: 100
number of threads: 1
number of transactions per client: 300
number of transactions actually processed: 30000/30000
tps = 444.281640 (including connections establishing)
tps = 446.328705 (excluding connections establishing)
установил
wal_buffers = 1024kB
/usr/pgsql/bin/pgbench -c 100 -t 300 alex
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 1
query mode: simple
number of clients: 100
number of threads: 1
number of transactions per client: 300
number of transactions actually processed: 30000/30000
tps = 673.658917 (including connections establishing)
tps = 678.406905 (excluding connections establishing)
