# The default values of these variables are driven from the -D command-line

# option or PGDATA environment variable, represented here as ConfigDir.

					# (change requires restart)

					# (change requires restart)

					# (change requires restart)

# If external_pid_file is not explicitly set, no extra PID file is written.

					# (change requires restart)

# - Connection Settings -

					# comma-separated list of addresses;

					# (change requires restart)

port = 5432				# (change requires restart)

max_connections = 100			# (change requires restart)

# connection slot, plus lock space (see max_locks_per_transaction).

#superuser_reserved_connections = 3	# (change requires restart)

#unix_socket_group = ''			# (change requires restart)

#unix_socket_permissions = 0777		# begin with 0 to use octal notation

					# (change requires restart)

#bonjour_name = ''			# defaults to the computer name

					# (change requires restart)

#authentication_timeout = 1min		# 1s-600s

ssl = true				# (change requires restart)

					# (change requires restart)

#ssl_renegotiation_limit = 512MB	# amount of data between renegotiations

#password_encryption = on

#db_user_namespace = off

# 32-bit Linux (e.g. Ubuntu VM) may support less:

# http://www.postgresql.org/message-id/27470.1323837026@sss.pgh.pa.us

shared_buffers = 2700MB			# min 128kB

					# (change requires restart)

#temp_buffers = 8MB			# min 800kB

#max_prepared_transactions = 0		# zero disables the feature

#maintenance_work_mem = 16MB		# min 1MB

#max_stack_depth = 2MB			# min 100kB

# - Kernel Resource Usage -

#max_files_per_process = 1000		# min 25

# - Cost-Based Vacuum Delay -

#vacuum_cost_page_hit = 1		# 0-10000 credits

#vacuum_cost_page_miss = 10		# 0-10000 credits

#vacuum_cost_page_dirty = 20		# 0-10000 credits

# - Asynchronous Behavior -

#------------------------------------------------------------------------------

# - Settings -

#fsync = on				# turns forced synchronization on or off

##### WARNING: Switching this off may cause data loss.

# It is used to improve performance with frequent commits. Each datasource makes

# <http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server#synchronous_commit>

#####

synchronous_commit = off		# immediate fsync at commit

					# supported by the operating system:

					#   open_datasync

					#   fsync

					#   fsync_writethrough

					#   open_sync

#full_page_writes = on			# recover from partial page writes

					# (change requires restart)

#wal_writer_delay = 200ms		# 1-10000 milliseconds

#archive_mode = off		# allows archiving to be done

				# (change requires restart)

#archive_command = ''		# command to use to archive a logfile segment

#archive_timeout = 0		# force a logfile segment switch after this

				# number of seconds; 0 disables

#------------------------------------------------------------------------------

# QUERY TUNING

#------------------------------------------------------------------------------

#enable_hashagg = on

#enable_hashjoin = on

#enable_indexscan = on

#enable_mergejoin = on

#enable_nestloop = on

#enable_seqscan = on

#geqo_pool_size = 0			# selects default based on effort

#geqo_generations = 0			# selects default based on effort

#geqo_selection_bias = 2.0		# range 1.5-2.0

# - Other Planner Options -

#constraint_exclusion = partition	# on, off, or partition

#cursor_tuple_fraction = 0.1		# range 0.0-1.0

#from_collapse_limit = 8

					# JOIN clauses

# - Where to Log -

#log_destination = 'stderr'		# Valid values are combinations of

					# depending on platform.  csvlog

					# requires logging_collector to be on.

					# can be absolute or relative to PGDATA

#log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'	# log file name pattern,

					# can include strftime() escapes

					# same name as the new log file will be

					# truncated rather than appended to.

					# But such truncation only occurs on

					# in all cases.

#log_rotation_age = 1d			# Automatic rotation of logfiles will

					# happen after that time.  0 disables.

					# happen after that much log output.

					# 0 disables.

#syslog_facility = 'LOCAL0'

#syslog_ident = 'postgres'

# - When to Log -

#client_min_messages = notice		# values in order of decreasing detail:

					#   fatal

					#   panic

#log_min_error_statement = error	# values in order of decreasing detail:

				 	#   debug5

					#   debug4

#log_connections = off

#log_disconnections = off

#log_duration = off

#log_hostname = off

log_line_prefix = '%t '			# special values:

					#   %u = user name

					#   %d = database name

					#   %r = remote host and port

					#   %t = timestamp without milliseconds

					#   %m = timestamp with milliseconds

					#   %i = command tag

					#   %c = session ID

					#   %l = session line number

					#   %s = session start timestamp

#log_temp_files = -1			# log temporary files equal or larger

					# than the specified size in kilobytes;

					# -1 disables, 0 logs all temp files

#------------------------------------------------------------------------------

#track_activities = on

#track_counts = on

#track_functions = none			# none, pl, all

#update_process_title = on

#stats_temp_directory = 'pg_stat_tmp'

# AUTOVACUUM PARAMETERS

#------------------------------------------------------------------------------

					# requires track_counts to also be on.

log_autovacuum_min_duration = 0	# -1 disables, 0 logs all actions and

					# their durations, > 0 logs only

					# actions running at least this number

					# of milliseconds.

#autovacuum_max_workers = 3		# max number of autovacuum subprocesses

#autovacuum_naptime = 1min		# time between autovacuum runs

#autovacuum_vacuum_threshold = 50	# min number of row updates before

					# vacuum

					# analyze

#autovacuum_vacuum_scale_factor = 0.2	# fraction of table size before vacuum

#autovacuum_analyze_scale_factor = 0.1	# fraction of table size before analyze

#check_function_bodies = on

#default_transaction_isolation = 'read committed'

#default_transaction_read_only = off

#session_replication_role = 'origin'

#statement_timeout = 0			# in milliseconds, 0 is disabled

#vacuum_freeze_min_age = 50000000

#vacuum_freeze_table_age = 150000000

#xmlbinary = 'base64'

#xmloption = 'content'

datestyle = 'iso, mdy'

#intervalstyle = 'postgres'

#timezone_abbreviations = 'Default'     # Select the set of available time zone

					# abbreviations.  Currently, there are

					#   Default

					#   India

					# You can create your own file in

					# share/timezonesets/.

#client_encoding = sql_ascii		# actually, defaults to database

					# encoding

# Note:  Each lock table slot uses ~270 bytes of shared memory, and there are

# max_locks_per_transaction * (max_connections + max_prepared_transactions)

# lock table slots.

#------------------------------------------------------------------------------

# - Previous PostgreSQL Versions -

#array_nulls = on

#backslash_quote = safe_encoding	# on, off, or safe_encoding

#default_with_oids = off

#escape_string_warning = on

#sql_inheritance = on

#synchronize_seqscans = on

# - Other Platforms and Clients -

#------------------------------------------------------------------------------

# CUSTOMIZED OPTIONS

#------------------------------------------------------------------------------