Strahinja Kustudic kustodian

## benchmark_postgres.sh
#!/bin/bash

POSTGRES_VERSION='9.5'

# With how many clients to do this test
CLIENTS="20"

# Duration of each test
DURATION=3600


## postgresql.conf
listen_addresses = '*'
port = 5432
max_connections = 200
shared_buffers = 4GB
work_mem = 1MB
maintenance_work_mem = 16MB
dynamic_shared_memory_type = posix
wal_level = minimal
fsync = on
synchronous_commit = off

## localhost.yml
# host_vars/localhost.yml
---
var1: inventory

## hostgroup_ips.j2
{% if myhostgroup != '' %}
{% for host in groups[myhostgroup] %}
- {{ hostvars[host]["ansible_default_ipv4"]["address"] }}
{% endfor %}
{% endif %}

## diskchecker.pl
#!/usr/bin/perl
#
# Brad's el-ghetto do-our-storage-stacks-lie?-script
#

sub usage {
    die <<'END';
Usage: diskchecker.pl -s <server[:port]> verify <file>
       diskchecker.pl -s <server[:port]> create <file> <size_in_MB>
       diskchecker.pl -l [port]
	#!/bin/bash

	POSTGRES_VERSION='9.5'

	# With how many clients to do this test
	CLIENTS="20"

	# Duration of each test
	DURATION=3600
	listen_addresses = '*'
	port = 5432
	max_connections = 200
	shared_buffers = 4GB
	work_mem = 1MB
	maintenance_work_mem = 16MB
	dynamic_shared_memory_type = posix
	wal_level = minimal
	fsync = on
	synchronous_commit = off
	{% if myhostgroup != '' %}
	{% for host in groups[myhostgroup] %}
	- {{ hostvars[host]["ansible_default_ipv4"]["address"] }}
	{% endfor %}
	{% endif %}
	#!/usr/bin/perl
	#
	# Brad's el-ghetto do-our-storage-stacks-lie?-script
	#

	sub usage {
	die <<'END';
	Usage: diskchecker.pl -s <server[:port]> verify <file>
	diskchecker.pl -s <server[:port]> create <file> <size_in_MB>
	diskchecker.pl -l [port]