anchor.diff:  #
   #   name = value
   #
  -# (The '=' is optional.)  White space may be used.  Comments are introduced
  -# with '#' anywhere on a line.  The complete list of option names and
  -# allowed values can be found in the PostgreSQL documentation.  The
  -# commented-out settings shown in this file represent the default values.
  -#
  -# Please note that re-commenting a setting is NOT sufficient to revert it
  -# to the default value, unless you restart the server.
  -#
  -# Any option can also be given as a command line switch to the server,
  -# e.g., 'postgres -c log_connections=on'.  Some options can be changed at
  -# run-time with the 'SET' SQL command.
  -#
  -# This file is read on server startup and when the server receives a
  -# SIGHUP.  If you edit the file on a running system, you have to SIGHUP the
  -# server for the changes to take effect, or use "pg_ctl reload". Some
  -# settings, which are marked below, require a server shutdown and restart
  -# to take effect.
  -#
  -# Memory units:  kB = kilobytes MB = megabytes GB = gigabytes
  -# Time units:    ms = milliseconds s = seconds min = minutes h = hours d = days
  -
  -
  -#---------------------------------------------------------------------------
  +# (The "=" is optional.)  Whitespace may be used.  Comments are introduced with
  +# "#" anywhere on a line.  The complete list of parameter names and allowed
  +# values can be found in the PostgreSQL documentation.
  +#
  +# The commented-out settings shown in this file represent the default values.
  +# Re-commenting a setting is NOT sufficient to revert it to the default value;
  +# you need to reload the server.
  +#
  +# This file is read on server startup and when the server receives a SIGHUP
  +# signal.  If you edit the file on a running system, you have to SIGHUP the
  +# server for the changes to take effect, or use "pg_ctl reload".  Some
  +# parameters, which are marked below, require a server shutdown and restart to
  +# take effect.
  +#
  +# Any parameter can also be given as a command-line option to the server, e.g.,
  +# "postgres -c log_connections=on".  Some parameters can be changed at run time
  +# with the "SET" SQL command.
  +#
  +# Memory units:  kB = kilobytes        Time units:  ms  = milliseconds
  +#                MB = megabytes                     s   = seconds
  +#                GB = gigabytes                     min = minutes
  +#                                                   h   = hours
  +#                                                   d   = days
  +
  +
  +#------------------------------------------------------------------------------
   # FILE LOCATIONS
  -#---------------------------------------------------------------------------
  -
  -# The default values of these variables are driven from the -D command line
  -# switch or PGDATA environment variable, represented here as ConfigDir.
  -
  -#data_directory = 'ConfigDir'       # use data in another directory
  -                    # (change requires restart)
  -#hba_file = 'ConfigDir/pg_hba.conf' # host-based authentication file
  -                    # (change requires restart)
  +#------------------------------------------------------------------------------
  +
  +# The default values of these variables are driven from the -D command-line
  +# option or PGDATA environment variable, represented here as ConfigDir.
  +
  +#data_directory = 'ConfigDir'                     # use data in another directory
  +                         # (change requires restart)
  +#hba_file = 'ConfigDir/pg_hba.conf'     # host-based authentication file
  +                         # (change requires restart)
   #ident_file = 'ConfigDir/pg_ident.conf' # ident configuration file
  -                    # (change requires restart)
  +                         # (change requires restart)
   
   # If external_pid_file is not explicitly set, no extra PID file is written.
  -#external_pid_file = '(none)'       # write an extra PID file
  -                    # (change requires restart)
  -
  -
  -#---------------------------------------------------------------------------
  +#external_pid_file = ''            # write an extra PID file
  +                         # (change requires restart)
  +
  +
  +#------------------------------------------------------------------------------
   # CONNECTIONS AND AUTHENTICATION
  -#---------------------------------------------------------------------------
  +#------------------------------------------------------------------------------
   
   # - Connection Settings -
   
  -#listen_addresses = 'localhost'     # what IP address(es) to listen on;
  -                    # comma-separated list of addresses;
  -                    # defaults to 'localhost', '*' = all
  -                    # (change requires restart)
  -#port = 5432                # (change requires restart)
  -max_connections = 100           # (change requires restart)
  -# Note: increasing max_connections costs ~400 bytes of shared memory per
  -# connection slot, plus lock space (see max_locks_per_transaction).  You
  -# might also need to raise shared_buffers to support more connections.
  -#superuser_reserved_connections = 3 # (change requires restart)
  -unix_socket_directory = '/tmp/'     # (change requires restart)
  -#unix_socket_group = ''         # (change requires restart)
  -#unix_socket_permissions = 0777     # octal
  -                    # (change requires restart)
  -#bonjour_name = ''          # defaults to the computer name
  -                    # (change requires restart)
  -
  -# - Security & Authentication -
  -
  -#authentication_timeout = 1min      # 1s-600s
  -#ssl = on              # (change requires restart)
  -#ssl_renegotiation_limit = 512MB    # amount of data between renegotiations
  +#listen_addresses = 'localhost'         # what IP address(es) to listen on;
  +                         # comma-separated list of addresses;
  +                         # defaults to 'localhost'; use '*' for all
  +                         # (change requires restart)
  +#port = 5432                  # (change requires restart)
  +max_connections = 100              # (change requires restart)
  +# Note:  Increasing max_connections costs ~400 bytes of shared memory per
  +# connection slot, plus lock space (see max_locks_per_transaction).
  +#superuser_reserved_connections = 3     # (change requires restart)
  +#unix_socket_directories = '/tmp'  # comma-separated list of directories
  +                         # (change requires restart)
  +#unix_socket_group = ''            # (change requires restart)
  +#unix_socket_permissions = 0777         # begin with 0 to use octal notation
  +                         # (change requires restart)
  +#bonjour = off                # advertise server via Bonjour
  +                         # (change requires restart)
  +#bonjour_name = ''            # defaults to the computer name
  +                         # (change requires restart)
  +
  +# - Security and Authentication -
  +
  +#authentication_timeout = 1min          # 1s-600s
  +#ssl = off                    # (change requires restart)
  +#ssl_ciphers = 'DEFAULT:!LOW:!EXP:!MD5:@STRENGTH' # allowed SSL ciphers
  +                         # (change requires restart)
  +#ssl_renegotiation_limit = 512MB   # amount of data between renegotiations
  +#ssl_cert_file = 'server.crt'      # (change requires restart)
  +#ssl_key_file = 'server.key'       # (change requires restart)
  +#ssl_ca_file = ''             # (change requires restart)
  +#ssl_crl_file = ''            # (change requires restart)
   #password_encryption = on
   #db_user_namespace = off
   
  -# Kerberos
  -#krb_server_keyfile = ''        # (change requires restart)
  -#krb_srvname = 'postgres'       # (change requires restart)
  -#krb_server_hostname = ''       # empty string matches any keytab entry
  +# Kerberos and GSSAPI
  +#krb_server_keyfile = ''
  +#krb_srvname = 'postgres'          # (Kerberos only)
  +#krb_caseins_users = off
  +
  +# - TCP Keepalives -
  +# see "man 7 tcp" for details
  +
  +#tcp_keepalives_idle = 0      # TCP_KEEPIDLE, in seconds;
  +                         # 0 selects the system default
  +#tcp_keepalives_interval = 0       # TCP_KEEPINTVL, in seconds;
  +                         # 0 selects the system default
  +#tcp_keepalives_count = 0          # TCP_KEEPCNT;
  +                         # 0 selects the system default
  +
  +
  +#------------------------------------------------------------------------------
  +# RESOURCE USAGE (except WAL)
  +#------------------------------------------------------------------------------
  +
  +# - Memory -
  +
  +shared_buffers = 256MB             # min 128kB
  +                         # (change requires restart)
  +temp_buffers = 16MB           # min 800kB
  +#max_prepared_transactions = 0          # zero disables the feature
  +                         # (change requires restart)
  +# Note:  Increasing max_prepared_transactions costs ~600 bytes of shared memory
  +# per transaction slot, plus lock space (see max_locks_per_transaction).
  +# It is not advisable to set max_prepared_transactions nonzero unless you
  +# actively intend to use prepared transactions.
  +work_mem = 32MB                    # min 64kB
  +maintenance_work_mem = 256MB       # min 1MB
  +#max_stack_depth = 2MB             # min 100kB
  +
  +# - Disk -
  +
  +#temp_file_limit = -1              # limits per-session temp file space
  +                         # in kB, or -1 for no limit
  +
  +# - Kernel Resource Usage -
  +
  +#max_files_per_process = 1000      # min 25
  +                         # (change requires restart)
  +#shared_preload_libraries = ''          # (change requires restart)
  +
  +# - Cost-Based Vacuum Delay -
  +
  +#vacuum_cost_delay = 0             # 0-100 milliseconds
  +#vacuum_cost_page_hit = 1          # 0-10000 credits
  +#vacuum_cost_page_miss = 10        # 0-10000 credits
  +#vacuum_cost_page_dirty = 20       # 0-10000 credits
  +#vacuum_cost_limit = 200      # 1-10000 credits
  +
  +# - Background Writer -
  +
  +#bgwriter_delay = 200ms            # 10-10000ms between rounds
  +#bgwriter_lru_maxpages = 100       # 0-1000 max buffers written/round
  +#bgwriter_lru_multiplier = 2.0          # 0-10.0 multipler on buffers scanned/round
  +
  +# - Asynchronous Behavior -
  +
  +#effective_io_concurrency = 1      # 1-1000; 0 disables prefetching
  +
  +
  +#------------------------------------------------------------------------------
  +# WRITE AHEAD LOG
  +#------------------------------------------------------------------------------
  +
  +# - Settings -
  +
  +#wal_level = minimal               # minimal, archive, or hot_standby
  +                         # (change requires restart)
  +fsync = off                   # turns forced synchronization on or off
  +#synchronous_commit = on      # synchronization level;
  +                         # off, local, remote_write, or on
  +#wal_sync_method = fsync      # the default is the first option
  +                         # supported by the operating system:
  +                         #   open_datasync
  +                         #   fdatasync (default on Linux)
  +                         #   fsync
  +                         #   fsync_writethrough
  +                         #   open_sync
  +#full_page_writes = on             # recover from partial page writes
  +#wal_buffers = -1             # min 32kB, -1 sets based on shared_buffers
  +                         # (change requires restart)
  +#wal_writer_delay = 200ms          # 1-10000 milliseconds
  +
  +#commit_delay = 0             # range 0-100000, in microseconds
  +#commit_siblings = 5               # range 1-1000
  +
  +# - Checkpoints -
  +
  +#checkpoint_segments = 3      # in logfile segments, min 1, 16MB each
  +#checkpoint_timeout = 5min         # range 30s-1h
  +#checkpoint_completion_target = 0.5     # checkpoint target duration, 0.0 - 1.0
  +#checkpoint_warning = 30s          # 0 disables
  +
  +# - Archiving -
  +
  +#archive_mode = off      # allows archiving to be done
                       # (change requires restart)
  -#krb_caseins_users = off        # (change requires restart)
  -
  -# - TCP Keepalives -
  -# see 'man 7 tcp' for details
  -
  -#tcp_keepalives_idle = 0        # TCP_KEEPIDLE, in seconds;
  -                    # 0 selects the system default
  -#tcp_keepalives_interval = 0        # TCP_KEEPINTVL, in seconds;
  -                    # 0 selects the system default
  -#tcp_keepalives_count = 0       # TCP_KEEPCNT;
  -                    # 0 selects the system default
  -
  -
  -#---------------------------------------------------------------------------
  -# RESOURCE USAGE (except WAL)
  -#---------------------------------------------------------------------------
  -
  -# - Memory -
  -
  -shared_buffers = 256MB          # min 128kB or max_connections*16kB
  +#archive_command = ''         # command to use to archive a logfile segment
  +                    # placeholders: %p = path of file to archive
  +                    #               %f = file name only
  +                    # e.g. 'test ! -f /mnt/server/archivedir/%f && cp %p /mnt/server/archivedir/%f'
  +#archive_timeout = 0          # force a logfile segment switch after this
  +                    # number of seconds; 0 disables
  +
  +
  +#------------------------------------------------------------------------------
  +# REPLICATION
  +#------------------------------------------------------------------------------
  +
  +# - Sending Server(s) -
  +
  +# Set these on the master and on any standby that will send replication data.
  +
  +#max_wal_senders = 0          # max number of walsender processes
                       # (change requires restart)
  -#temp_buffers = 8MB         # min 800kB
  -#max_prepared_transactions = 5      # can be 0 or more
  -                    # (change requires restart)
  -# Note: increasing max_prepared_transactions costs ~600 bytes of shared memory
  -# per transaction slot, plus lock space (see max_locks_per_transaction).
  -work_mem = 32MB             # min 64kB
  -maintenance_work_mem = 256MB        # min 1MB
  -#max_stack_depth = 2MB          # min 100kB
  -
  -# - Free Space Map -
  -
  -#max_fsm_pages = 204800     # min max_fsm_relations*16, 6 bytes each
  -                    # (change requires restart)
  -#max_fsm_relations = 1000       # min 100, ~70 bytes each
  -                    # (change requires restart)
  -
  -# - Kernel Resource Usage -
  -
  -#max_files_per_process = 1000       # min 25
  -                    # (change requires restart)
  -#shared_preload_libraries = ''      # (change requires restart)
  -
  -# - Cost-Based Vacuum Delay -
  -
  -#vacuum_cost_delay = 0          # 0-1000 milliseconds
  -#vacuum_cost_page_hit = 1       # 0-10000 credits
  -#vacuum_cost_page_miss = 10     # 0-10000 credits
  -#vacuum_cost_page_dirty = 20        # 0-10000 credits
  -#vacuum_cost_limit = 200        # 0-10000 credits
  -
  -# - Background writer -
  -
  -#bgwriter_delay = 200ms         # 10-10000ms between rounds
  -#bgwriter_lru_percent = 1.0     # 0-100% of LRU buffers scanned/round
  -#bgwriter_lru_maxpages = 5      # 0-1000 buffers max written/round
  -#bgwriter_all_percent = 0.333       # 0-100% of all buffers scanned/round
  -#bgwriter_all_maxpages = 5      # 0-1000 buffers max written/round
  -
  -
  -#---------------------------------------------------------------------------
  -# WRITE AHEAD LOG
  -#---------------------------------------------------------------------------
  -
  -# - Settings -
  -
  -fsync = off         # turns forced synchronization on or off
  -#wal_sync_method = fsync        # the default is the first option
  -                    # supported by the operating system:
  -                    #   open_datasync
  -                    #   fdatasync (default on Linux)
  -                    #   fsync
  -                    #   fsync_writethrough
  -                    #   open_sync
  -#full_page_writes = on          # recover from partial page writes
  -wal_buffers = 16MB          # min 32kB
  -                    # (change requires restart)
  -#commit_delay = 0           # range 0-100000, in microseconds
  -#commit_siblings = 5            # range 1-1000
  -
  -# - Checkpoints -
  -
  -checkpoint_segments = 32        # in logfile segments, min 1, 16MB each
  -#checkpoint_timeout = 5min      # range 30s-1h
  -#checkpoint_warning = 30s       # 0 is off
  -
  -# - Archiving -
  -
  -#archive_command = ''       # command to use to archive a logfile segment
  -#archive_timeout = 0        # force a logfile segment switch after this
  -                # many seconds; 0 is off
  -
  -
  -#---------------------------------------------------------------------------
  +#wal_keep_segments = 0        # in logfile segments, 16MB each; 0 disables
  +#wal_sender_timeout = 60s     # in milliseconds; 0 disables
  +
  +# - Master Server -
  +
  +# These settings are ignored on a standby server.
  +
  +#synchronous_standby_names = ''    # standby servers that provide sync rep
  +                    # comma-separated list of application_name
  +                    # from standby(s); '*' = all
  +#vacuum_defer_cleanup_age = 0 # number of xacts by which cleanup is delayed
  +
  +# - Standby Servers -
  +
  +# These settings are ignored on a master server.
  +
  +#hot_standby = off            # "on" allows queries during recovery
  +                         # (change requires restart)
  +#max_standby_archive_delay = 30s   # max delay before canceling queries
  +                         # when reading WAL from archive;
  +                         # -1 allows indefinite delay
  +#max_standby_streaming_delay = 30s # max delay before canceling queries
  +                         # when reading streaming WAL;
  +                         # -1 allows indefinite delay
  +#wal_receiver_status_interval = 10s     # send replies at least this often
  +                         # 0 disables
  +#hot_standby_feedback = off        # send info from standby to prevent
  +                         # query conflicts
  +#wal_receiver_timeout = 60s        # time that receiver waits for
  +                         # communication from master
  +                         # in milliseconds; 0 disables
  +
  +
  +#------------------------------------------------------------------------------
   # QUERY TUNING
  -#---------------------------------------------------------------------------
  +#------------------------------------------------------------------------------
   
   # - Planner Method Configuration -
   
  
positive.code: #log_statement_stats = off
  
  
  #---------------------------------------------------------------------------
  # AUTOVACUUM PARAMETERS
  #---------------------------------------------------------------------------
  
  #autovacuum = off           # enable autovacuum subprocess?
                      # 'on' requires stats_start_collector
                      # and stats_row_level to also be on
  #autovacuum_naptime = 1min      # time between autovacuum runs
  #autovacuum_vacuum_threshold = 500  # min # of tuple updates before
                      # vacuum
  #autovacuum_analyze_threshold = 250 # min # of tuple updates before
                      # analyze
  #autovacuum_vacuum_scale_factor = 0.2   # fraction of rel size before
                      # vacuum
  #autovacuum_analyze_scale_factor = 0.1  # fraction of rel size before
                      # analyze
  #autovacuum_freeze_max_age = 200000000  # maximum XID age before forced vacuum
                      # (change requires restart)
  #autovacuum_vacuum_cost_delay = -1  # default vacuum cost delay for
                      # autovacuum, -1 means use
                      # vacuum_cost_delay
  #autovacuum_vacuum_cost_limit = -1  # default vacuum cost limit for
                      # autovacuum, -1 means use
                      # vacuum_cost_limit
  
  
  #---------------------------------------------------------------------------
  # CLIENT CONNECTION DEFAULTS
  #---------------------------------------------------------------------------
  
  # - Statement Behavior -
  
  #search_path = '"$user",public'     # schema names
  #default_tablespace = ''        # a tablespace name, '' uses
                      # the default
  #check_function_bodies = on
  #default_transaction_isolation = 'read committed'
  #default_transaction_read_only = off
  #statement_timeout = 0          # 0 is disabled
  #vacuum_freeze_min_age = 100000000
  
  # - Locale and Formatting -
  
  datestyle = 'iso, mdy'
  #timezone = unknown         # actually, defaults to TZ
                      # environment setting
  #timezone_abbreviations = 'Default'     # select the set of available timezone
                      # abbreviations. Currently, there are
                      #   Default
                      #   Australia
                      #   India
                      # However you can also create your own
                      # file in share/timezonesets/.
  #extra_float_digits = 0         # min -15, max 2
  #client_encoding = sql_ascii        # actually, defaults to database
                      # encoding
  
  # These settings are initialized by initdb -- they might be changed
  lc_messages = 'en_US.UTF-8'         # locale for system error message
                      # strings
  lc_monetary = 'en_US.UTF-8'         # locale for monetary formatting
  lc_numeric = 'en_US.UTF-8'          # locale for number formatting
  lc_time = 'en_US.UTF-8'             # locale for time formatting
  
  # - Other Defaults -
  
  #explain_pretty_print = on
  #dynamic_library_path = '$libdir'
  #local_preload_libraries = ''
  
  
  #---------------------------------------------------------------------------
  # LOCK MANAGEMENT
  #---------------------------------------------------------------------------
  
  #deadlock_timeout = 1s
  #max_locks_per_transaction = 64     # min 10
                      # (change requires restart)
  # 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.
  
  
  #---------------------------------------------------------------------------
  # VERSION/PLATFORM COMPATIBILITY
  #---------------------------------------------------------------------------
  
  # - Previous Postgres Versions -
  
  #add_missing_from = off
  #array_nulls = on
  #backslash_quote = safe_encoding    # on, off, or safe_encoding
  #default_with_oids = off
  #escape_string_warning = on
  #standard_conforming_strings = off
  #regex_flavor = advanced        # advanced, extended, or basic
  #sql_inheritance = on
  
  # - Other Platforms & Clients -
  
  #transform_null_equals = off
  
  
  #---------------------------------------------------------------------------
  # CUSTOMIZED OPTIONS
  #---------------------------------------------------------------------------
  
  #custom_variable_classes = ''       # list of custom variable class names
  
  
  
  
  # postgresql.conf should contain...
  #unix_socket_directory = '/var/run/postgresql/'       # dont worry if yours is different
  #unix_socket_group = ''                             # default is fine here
  #unix_socket_permissions = 0777                     # check this one and uncomment if necessary.
  
  
  
negative.code: #enable_hashagg = on
  #enable_hashjoin = on
  #enable_indexscan = on
  #enable_indexonlyscan = on
  #enable_material = on
  #enable_mergejoin = on
  #enable_nestloop = on
  #enable_seqscan = on
  