pgtune.conf

# ------------------------------------------
# PostgreSQL configuration file customizations
# ------------------------------------------

#------------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#------------------------------------------------------------------------------

# - Connection Settings -

listen_addresses = '*'		# what IP address(es) to listen on;
					# comma-separated list of addresses;
					# defaults to 'localhost'; use '*' for all
					# (change requires restart)

#------------------------------------------------------------------------------
# pgtune run on 2013-12-31
# Based on 16777216 KB RAM, platform Darwin
#------------------------------------------------------------------------------

default_statistics_target = 100
maintenance_work_mem = 1GB
#effective_cache_size = 4GB
effective_cache_size = 6GB  # used beacon setting rather than pgtune
#work_mem = 52MB
work_mem = 500MB            # used beacon setting rather than pgtune
wal_buffers = 16MB
#shared_buffers = 1GB
shared_buffers = 4GB        # set to 1/4 mem
max_connections = 50
max_locks_per_transaction = 64