perf wrappers

kelvich · kelvich · commit 32af898e3ce4 · 2015-10-30T22:12:58.000+03:00
diff --git a/contrib/pg_dtm/tests/perf.sh b/contrib/pg_dtm/tests/perf.sh
@@ -0,0 +1,5 @@
+go run *.go  \
+-C "dbname=postgres user=stas port=5432 sslmode=disable" \
+-C "dbname=postgres user=stas port=5433 sslmode=disable" \
+-C "dbname=postgres user=stas port=5434 sslmode=disable" \
+-g -w 8 -r 1 -n 1000 -a 1000  -b pgshard -i
diff --git a/contrib/pg_dtm/tests/perf.yml b/contrib/pg_dtm/tests/perf.yml
@@ -0,0 +1,36 @@
+---
+
+- hosts: clients
+  gather_facts: no
+  tasks:
+
+  - name: generate connstrings
+    set_fact:
+      connstr: "-d 'host={{item}} user=cluster port=15432 dbname=postgres' "
+    with_items:
+      groups['nodes'] | reverse | batch(nnodes | d(2) | int) | first
+    register: connstrs
+
+  - name: make a list
+    set_fact:
+      connections: "{{ connstrs.results | map(attribute='ansible_facts.connstr') | join }}"
+
+  - name: copy transfers binary
+    copy: src=transfers.linux dest=~/transfers mode=a+x
+
+- hosts: clients[0]
+  gather_facts: no
+  tasks:
+  - name: fill the databases
+    shell: "./transfers {{connections}} -f -g"
+    register: transfers_result
+  - debug: "var=transfers_result"
+
+- hosts: clients
+  gather_facts: no
+  tasks:
+  - name: run transfers
+    shell: "./transfers {{connections}} -s {{runkeys | d('-g -w 60 -m -o -u 10000 -r 0')}} -k {{hostvars[inventory_hostname]['offset']}} "
+    register: transfers_result
+  - debug: var=transfers_result
+
