Changeset 976


Ignore:
Timestamp:
Oct 1, 2008, 3:13:42 AM (16 years ago)
Author:
broder
Message:

Update sipb-xen-database for Postgres 8.3

Location:
trunk/packages/sipb-xen-database
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • trunk/packages/sipb-xen-database/debian/changelog

    r974 r976  
     1sipb-xen-database (10.24) unstable; urgency=low
     2
     3  * Update postgresql.conf for Hardy
     4
     5 -- Evan Broder <broder@mit.edu>  Wed, 01 Oct 2008 03:12:36 -0400
     6
    17sipb-xen-database (10.23) unstable; urgency=low
    28
  • trunk/packages/sipb-xen-database/server/etc/postgresql/8.3/main/postgresql.conf.invirt

    r974 r976  
    77#   name = value
    88#
    9 # (The '=' is optional.) White space may be used. Comments are introduced
    10 # with '#' anywhere on a line. The complete list of option names and
    11 # allowed values can be found in the PostgreSQL documentation. The
    12 # commented-out settings shown in this file represent the default values.
    13 #
    14 # Please note that re-commenting a setting is NOT sufficient to revert it
    15 # to the default value, unless you restart the postmaster.
    16 #
    17 # Any option can also be given as a command line switch to the
    18 # postmaster, e.g. 'postmaster -c log_connections=on'. Some options
    19 # can be changed at run-time with the 'SET' SQL command.
    20 #
    21 # This file is read on postmaster startup and when the postmaster
    22 # receives a SIGHUP. If you edit the file on a running system, you have
    23 # to SIGHUP the postmaster for the changes to take effect, or use
    24 # "pg_ctl reload". Some settings, such as listen_addresses, require
    25 # a postmaster shutdown and restart to take effect.
    26 
    27 
    28 #---------------------------------------------------------------------------
     9# (The "=" is optional.)  Whitespace may be used.  Comments are introduced with
     10# "#" anywhere on a line.  The complete list of parameter names and allowed
     11# values can be found in the PostgreSQL documentation.
     12#
     13# The commented-out settings shown in this file represent the default values.
     14# Re-commenting a setting is NOT sufficient to revert it to the default value;
     15# you need to reload the server.
     16#
     17# This file is read on server startup and when the server receives a SIGHUP
     18# signal.  If you edit the file on a running system, you have to SIGHUP the
     19# server for the changes to take effect, or use "pg_ctl reload".  Some
     20# parameters, which are marked below, require a server shutdown and restart to
     21# take effect.
     22#
     23# Any parameter can also be given as a command-line option to the server, e.g.,
     24# "postgres -c log_connections=on".  Some paramters can be changed at run time
     25# with the "SET" SQL command.
     26#
     27# Memory units:  kB = kilobytes MB = megabytes GB = gigabytes
     28# Time units:    ms = milliseconds s = seconds min = minutes h = hours d = days
     29
     30
     31#------------------------------------------------------------------------------
    2932# FILE LOCATIONS
    30 #---------------------------------------------------------------------------
    31 
    32 # The default values of these variables are driven from the -D command line
    33 # switch or PGDATA environment variable, represented here as ConfigDir.
    34 
    35 #data_directory = 'ConfigDir'           # use data in another directory
     33#------------------------------------------------------------------------------
     34
     35# The default values of these variables are driven from the -D command-line
     36# option or PGDATA environment variable, represented here as ConfigDir.
     37
     38data_directory = '/var/lib/postgresql/8.3/main'         # use data in another directory
     39                                        # (change requires restart)
    3640hba_file = '/etc/postgresql/8.3/main/pg_hba.conf'       # host-based authentication file
    37 ident_file = '/etc/postgresql/8.3/main/pg_ident.conf'   # IDENT configuration file
    38 
    39 # If external_pid_file is not explicitly set, no extra pid file is written.
    40 external_pid_file = '/var/run/postgresql/8.3-main.pid'          # write an extra pid file
    41 
    42 
    43 #---------------------------------------------------------------------------
     41                                        # (change requires restart)
     42ident_file = '/etc/postgresql/8.3/main/pg_ident.conf'   # ident configuration file
     43                                        # (change requires restart)
     44
     45# If external_pid_file is not explicitly set, no extra PID file is written.
     46external_pid_file = '/var/run/postgresql/8.3-main.pid'          # write an extra PID file
     47                                        # (change requires restart)
     48
     49
     50#------------------------------------------------------------------------------
    4451# CONNECTIONS AND AUTHENTICATION
    45 #---------------------------------------------------------------------------
     52#------------------------------------------------------------------------------
    4653
    4754# - Connection Settings -
    4855
    49 listen_addresses = '*'          # what IP address(es) to listen on;
     56listen_addresses = '*'                  # what IP address(es) to listen on;
    5057                                        # comma-separated list of addresses;
    5158                                        # defaults to 'localhost', '*' = all
    52 port = 5432
    53 max_connections = 100
    54 # note: increasing max_connections costs ~400 bytes of shared memory per
    55 # connection slot, plus lock space (see max_locks_per_transaction).  You
    56 # might also need to raise shared_buffers to support more connections.
    57 #superuser_reserved_connections = 2
    58 unix_socket_directory = '/var/run/postgresql'
    59 #unix_socket_group = ''
    60 #unix_socket_permissions = 0777         # octal
     59                                        # (change requires restart)
     60port = 5432                             # (change requires restart)
     61max_connections = 100                   # (change requires restart)
     62# Note:  Increasing max_connections costs ~400 bytes of shared memory per
     63# connection slot, plus lock space (see max_locks_per_transaction).  You might
     64# also need to raise shared_buffers to support more connections.
     65#superuser_reserved_connections = 3     # (change requires restart)
     66unix_socket_directory = '/var/run/postgresql'           # (change requires restart)
     67#unix_socket_group = ''                 # (change requires restart)
     68#unix_socket_permissions = 0777         # begin with 0 to use octal notation
     69                                        # (change requires restart)
    6170#bonjour_name = ''                      # defaults to the computer name
    62 
    63 # - Security & Authentication -
    64 
    65 #authentication_timeout = 60            # 1-600, in seconds
    66 ssl = true
     71                                        # (change requires restart)
     72
     73# - Security and Authentication -
     74
     75#authentication_timeout = 1min          # 1s-600s
     76ssl = true                              # (change requires restart)
     77#ssl_ciphers = 'ALL:!ADH:!LOW:!EXP:!MD5:@STRENGTH'      # allowed SSL ciphers
     78                                        # (change requires restart)
    6779#password_encryption = on
    6880#db_user_namespace = off
    6981
    70 # Kerberos
    71 #krb_server_keyfile = ''
    72 #krb_srvname = 'postgres'
     82# Kerberos and GSSAPI
     83#krb_server_keyfile = ''                # (change requires restart)
     84#krb_srvname = 'postgres'               # (change requires restart, Kerberos only)
    7385#krb_server_hostname = ''               # empty string matches any keytab entry
    74 #krb_caseins_users = off
     86                                        # (change requires restart, Kerberos only)
     87#krb_caseins_users = off                # (change requires restart)
     88#krb_realm = ''                         # (change requires restart)
    7589
    7690# - TCP Keepalives -
    77 # see 'man 7 tcp' for details
     91# see "man 7 tcp" for details
    7892
    7993#tcp_keepalives_idle = 0                # TCP_KEEPIDLE, in seconds;
     
    8599
    86100
    87 #---------------------------------------------------------------------------
     101#------------------------------------------------------------------------------
    88102# RESOURCE USAGE (except WAL)
    89 #---------------------------------------------------------------------------
     103#------------------------------------------------------------------------------
    90104
    91105# - Memory -
    92106
    93 shared_buffers = 1000                   # min 16 or max_connections*2, 8KB each
    94 #temp_buffers = 1000                    # min 100, 8KB each
     107shared_buffers = 24MB                   # min 128kB or max_connections*16kB
     108                                        # (change requires restart)
     109#temp_buffers = 8MB                     # min 800kB
    95110#max_prepared_transactions = 5          # can be 0 or more
    96 # note: increasing max_prepared_transactions costs ~600 bytes of shared memory
     111                                        # (change requires restart)
     112# Note:  Increasing max_prepared_transactions costs ~600 bytes of shared memory
    97113# per transaction slot, plus lock space (see max_locks_per_transaction).
    98 #work_mem = 1024                        # min 64, size in KB
    99 #maintenance_work_mem = 16384           # min 1024, size in KB
    100 #max_stack_depth = 2048                 # min 100, size in KB
     114#work_mem = 1MB                         # min 64kB
     115#maintenance_work_mem = 16MB            # min 1MB
     116#max_stack_depth = 2MB                  # min 100kB
    101117
    102118# - Free Space Map -
    103119
    104 #max_fsm_pages = 20000                  # min max_fsm_relations*16, 6 bytes each
     120max_fsm_pages = 153600                  # min max_fsm_relations*16, 6 bytes each
     121                                        # (change requires restart)
    105122#max_fsm_relations = 1000               # min 100, ~70 bytes each
     123                                        # (change requires restart)
    106124
    107125# - Kernel Resource Usage -
    108126
    109127#max_files_per_process = 1000           # min 25
    110 #preload_libraries = ''
     128                                        # (change requires restart)
     129#shared_preload_libraries = ''          # (change requires restart)
    111130
    112131# - Cost-Based Vacuum Delay -
     
    116135#vacuum_cost_page_miss = 10             # 0-10000 credits
    117136#vacuum_cost_page_dirty = 20            # 0-10000 credits
    118 #vacuum_cost_limit = 200                # 0-10000 credits
    119 
    120 # - Background writer -
    121 
    122 #bgwriter_delay = 200                   # 10-10000 milliseconds between rounds
    123 #bgwriter_lru_percent = 1.0             # 0-100% of LRU buffers scanned/round
    124 #bgwriter_lru_maxpages = 5              # 0-1000 buffers max written/round
    125 #bgwriter_all_percent = 0.333           # 0-100% of all buffers scanned/round
    126 #bgwriter_all_maxpages = 5              # 0-1000 buffers max written/round
    127 
    128 
    129 #---------------------------------------------------------------------------
     137#vacuum_cost_limit = 200                # 1-10000 credits
     138
     139# - Background Writer -
     140
     141#bgwriter_delay = 200ms                 # 10-10000ms between rounds
     142#bgwriter_lru_maxpages = 100            # 0-1000 max buffers written/round
     143#bgwriter_lru_multiplier = 2.0          # 0-10.0 multipler on buffers scanned/round
     144
     145
     146#------------------------------------------------------------------------------
    130147# WRITE AHEAD LOG
    131 #---------------------------------------------------------------------------
     148#------------------------------------------------------------------------------
    132149
    133150# - Settings -
    134151
    135152#fsync = on                             # turns forced synchronization on or off
     153#synchronous_commit = on                # immediate fsync at commit
    136154#wal_sync_method = fsync                # the default is the first option
    137155                                        # supported by the operating system:
     
    142160                                        #   open_sync
    143161#full_page_writes = on                  # recover from partial page writes
    144 #wal_buffers = 8                        # min 4, 8KB each
     162#wal_buffers = 64kB                     # min 32kB
     163                                        # (change requires restart)
     164#wal_writer_delay = 200ms               # 1-10000 milliseconds
     165
    145166#commit_delay = 0                       # range 0-100000, in microseconds
    146167#commit_siblings = 5                    # range 1-1000
     
    149170
    150171#checkpoint_segments = 3                # in logfile segments, min 1, 16MB each
    151 #checkpoint_timeout = 300               # range 30-3600, in seconds
    152 #checkpoint_warning = 30                # in seconds, 0 is off
     172#checkpoint_timeout = 5min              # range 30s-1h
     173#checkpoint_completion_target = 0.5     # checkpoint target duration, 0.0 - 1.0
     174#checkpoint_warning = 30s               # 0 is off
    153175
    154176# - Archiving -
    155177
    156 #archive_command = ''                   # command to use to archive a logfile
    157                                         # segment
    158 
    159 
    160 #---------------------------------------------------------------------------
     178#archive_mode = off             # allows archiving to be done
     179                                # (change requires restart)
     180#archive_command = ''           # command to use to archive a logfile segment
     181#archive_timeout = 0            # force a logfile segment switch after this
     182                                # time; 0 is off
     183
     184
     185#------------------------------------------------------------------------------
    161186# QUERY TUNING
    162 #---------------------------------------------------------------------------
     187#------------------------------------------------------------------------------
    163188
    164189# - Planner Method Configuration -
     
    176201# - Planner Cost Constants -
    177202
    178 #effective_cache_size = 1000            # typically 8KB each
    179 #random_page_cost = 4                   # units are one sequential page fetch
    180                                         # cost
    181 #cpu_tuple_cost = 0.01                  # (same)
    182 #cpu_index_tuple_cost = 0.001           # (same)
    183 #cpu_operator_cost = 0.0025             # (same)
     203#seq_page_cost = 1.0                    # measured on an arbitrary scale
     204#random_page_cost = 4.0                 # same scale as above
     205#cpu_tuple_cost = 0.01                  # same scale as above
     206#cpu_index_tuple_cost = 0.005           # same scale as above
     207#cpu_operator_cost = 0.0025             # same scale as above
     208#effective_cache_size = 128MB
    184209
    185210# - Genetic Query Optimizer -
     
    198223#from_collapse_limit = 8
    199224#join_collapse_limit = 8                # 1 disables collapsing of explicit
    200                                         # JOINs
    201 
    202 
    203 #---------------------------------------------------------------------------
     225                                        # JOIN clauses
     226
     227
     228#------------------------------------------------------------------------------
    204229# ERROR REPORTING AND LOGGING
    205 #---------------------------------------------------------------------------
     230#------------------------------------------------------------------------------
    206231
    207232# - Where to Log -
    208233
    209 #log_destination = 'stderr'             # Valid values are combinations of
    210                                         # stderr, syslog and eventlog,
    211                                         # depending on platform.
     234#log_destination = 'stderr'             # Valid values are combinations of
     235                                        # stderr, csvlog, syslog and eventlog,
     236                                        # depending on platform.  csvlog
     237                                        # requires logging_collector to be on.
    212238
    213239# This is used when logging to stderr:
    214 #redirect_stderr = off                  # Enable capturing of stderr into log
    215                                         # files
    216 
    217 # These are only used if redirect_stderr is on:
    218 #log_directory = 'pg_log'               # Directory where log files are written
    219                                         # Can be absolute or relative to PGDATA
    220 #log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' # Log file name pattern.
    221                                         # Can include strftime() escapes
    222 #log_truncate_on_rotation = off # If on, any existing log file of the same
    223                                         # name as the new log file will be
    224                                         # truncated rather than appended to. But
    225                                         # such truncation only occurs on
     240#logging_collector = off                # Enable capturing of stderr and csvlog
     241                                        # into log files. Required to be on for
     242                                        # csvlogs.
     243                                        # (change requires restart)
     244
     245# These are only used if logging_collector is on:
     246#log_directory = 'pg_log'               # directory where log files are written,
     247                                        # can be absolute or relative to PGDATA
     248#log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'        # log file name pattern,
     249                                        # can include strftime() escapes
     250#log_truncate_on_rotation = off         # If on, an existing log file of the
     251                                        # same name as the new log file will be
     252                                        # truncated rather than appended to.
     253                                        # But such truncation only occurs on
    226254                                        # time-driven rotation, not on restarts
    227                                         # or size-driven rotation. Default is
     255                                        # or size-driven rotation.  Default is
    228256                                        # off, meaning append to existing files
    229257                                        # in all cases.
    230 #log_rotation_age = 1440                # Automatic rotation of logfiles will
    231                                         # happen after so many minutes.  0 to
    232                                         # disable.
    233 #log_rotation_size = 10240              # Automatic rotation of logfiles will
    234                                         # happen after so many kilobytes of log
    235                                         # output.  0 to disable.
     258#log_rotation_age = 1d                  # Automatic rotation of logfiles will
     259                                        # happen after that time.  0 to disable.
     260#log_rotation_size = 10MB               # Automatic rotation of logfiles will
     261                                        # happen after that much log output.
     262                                        # 0 to disable.
    236263
    237264# These are relevant when logging to syslog:
     
    242269# - When to Log -
    243270
    244 #client_min_messages = notice           # Values, in order of decreasing detail:
     271#client_min_messages = notice           # values in order of decreasing detail:
    245272                                        #   debug5
    246273                                        #   debug4
     
    253280                                        #   error
    254281
    255 #log_min_messages = notice              # Values, in order of decreasing detail:
     282#log_min_messages = notice              # values in order of decreasing detail:
    256283                                        #   debug5
    257284                                        #   debug4
     
    269296#log_error_verbosity = default          # terse, default, or verbose messages
    270297
    271 #log_min_error_statement = panic        # Values in order of increasing severity:
     298#log_min_error_statement = error        # values in order of decreasing detail:
    272299                                        #   debug5
    273300                                        #   debug4
     
    279306                                        #   warning
    280307                                        #   error
    281                                         #   panic(off)
    282                                  
     308                                        #   log
     309                                        #   fatal
     310                                        #   panic (effectively off)
     311
    283312#log_min_duration_statement = -1        # -1 is disabled, 0 logs all statements
    284                                         # and their durations, in milliseconds.
    285 
    286 #silent_mode = off                      # DO NOT USE without syslog or
    287                                         # redirect_stderr
     313                                        # and their durations, > 0 logs only
     314                                        # statements running at least this time.
     315
     316#silent_mode = off                      # DO NOT USE without syslog or
     317                                        # logging_collector
     318                                        # (change requires restart)
    288319
    289320# - What to Log -
     
    293324#debug_print_plan = off
    294325#debug_pretty_print = off
     326#log_checkpoints = off
    295327#log_connections = off
    296328#log_disconnections = off
    297329#log_duration = off
    298 log_line_prefix = '%t '                 # Special values:
     330#log_hostname = off
     331log_line_prefix = '%t '                 # special values:
    299332                                        #   %u = user name
    300333                                        #   %d = database name
    301334                                        #   %r = remote host and port
    302335                                        #   %h = remote host
    303                                         #   %p = PID
    304                                         #   %t = timestamp (no milliseconds)
     336                                        #   %p = process ID
     337                                        #   %t = timestamp without milliseconds
    305338                                        #   %m = timestamp with milliseconds
    306339                                        #   %i = command tag
    307                                         #   %c = session id
     340                                        #   %c = session ID
    308341                                        #   %l = session line number
    309342                                        #   %s = session start timestamp
    310                                         #   %x = transaction id
    311                                         #   %q = stop here in non-session
     343                                        #   %v = virtual transaction ID
     344                                        #   %x = transaction ID (0 if none)
     345                                        #   %q = stop here in non-session
    312346                                        #        processes
    313347                                        #   %% = '%'
    314348                                        # e.g. '<%u%%%d> '
    315 #log_statement = 'none'                 # none, mod, ddl, all
    316 #log_hostname = off
    317 
    318 
    319 #---------------------------------------------------------------------------
     349#log_lock_waits = off                   # log lock waits >= deadlock_timeout
     350#log_statement = 'none'                 # none, ddl, mod, all
     351#log_temp_files = -1                    # log temporary files equal or larger
     352                                        # than specified size;
     353                                        # -1 disables, 0 logs all temp files
     354#log_timezone = unknown                 # actually, defaults to TZ environment
     355                                        # setting
     356
     357
     358#------------------------------------------------------------------------------
    320359# RUNTIME STATISTICS
    321 #---------------------------------------------------------------------------
     360#------------------------------------------------------------------------------
     361
     362# - Query/Index Statistics Collector -
     363
     364#track_activities = on
     365#track_counts = on
     366#update_process_title = on
     367
    322368
    323369# - Statistics Monitoring -
     
    328374#log_statement_stats = off
    329375
    330 # - Query/Index Statistics Collector -
    331 
    332 #stats_start_collector = on
    333 #stats_command_string = off
    334 #stats_block_level = off
    335 stats_row_level = on
    336 #stats_reset_on_server_start = off
    337 
    338 
    339 #---------------------------------------------------------------------------
     376
     377#------------------------------------------------------------------------------
    340378# AUTOVACUUM PARAMETERS
    341 #---------------------------------------------------------------------------
    342 
    343 autovacuum = on                 # enable autovacuum subprocess?
    344 #autovacuum_naptime = 60                # time between autovacuum runs, in secs
    345 #autovacuum_vacuum_threshold = 1000     # min # of tuple updates before
     379#------------------------------------------------------------------------------
     380
     381#autovacuum = on                        # Enable autovacuum subprocess?  'on'
     382                                        # requires track_counts to also be on.
     383#log_autovacuum_min_duration = -1       # -1 disables, 0 logs all actions and
     384                                        # their durations, > 0 logs only
     385                                        # actions running at least that time.
     386#autovacuum_max_workers = 3             # max number of autovacuum subprocesses
     387#autovacuum_naptime = 1min              # time between autovacuum runs
     388#autovacuum_vacuum_threshold = 50       # min number of row updates before
    346389                                        # vacuum
    347 #autovacuum_analyze_threshold = 500     # min # of tuple updates before
     390#autovacuum_analyze_threshold = 50      # min number of row updates before
    348391                                        # analyze
    349 #autovacuum_vacuum_scale_factor = 0.4   # fraction of rel size before
    350                                         # vacuum
    351 #autovacuum_analyze_scale_factor = 0.2  # fraction of rel size before
    352                                         # analyze
    353 #autovacuum_vacuum_cost_delay = -1      # default vacuum cost delay for
    354                                         # autovac, -1 means use
     392#autovacuum_vacuum_scale_factor = 0.2   # fraction of table size before vacuum
     393#autovacuum_analyze_scale_factor = 0.1  # fraction of table size before analyze
     394#autovacuum_freeze_max_age = 200000000  # maximum XID age before forced vacuum
     395                                        # (change requires restart)
     396#autovacuum_vacuum_cost_delay = 20      # default vacuum cost delay for
     397                                        # autovacuum, -1 means use
    355398                                        # vacuum_cost_delay
    356 #autovacuum_vacuum_cost_limit = -1      # default vacuum cost limit for 
    357                                         # autovac, -1 means use
     399#autovacuum_vacuum_cost_limit = -1      # default vacuum cost limit for
     400                                        # autovacuum, -1 means use
    358401                                        # vacuum_cost_limit
    359402
    360403
    361 #---------------------------------------------------------------------------
     404#------------------------------------------------------------------------------
    362405# CLIENT CONNECTION DEFAULTS
    363 #---------------------------------------------------------------------------
     406#------------------------------------------------------------------------------
    364407
    365408# - Statement Behavior -
    366409
    367 #search_path = '$user,public'           # schema names
    368 #default_tablespace = ''                # a tablespace name, '' uses
    369                                         # the default
     410#search_path = '"$user",public'         # schema names
     411#default_tablespace = ''                # a tablespace name, '' uses the default
     412#temp_tablespaces = ''                  # a list of tablespace names, '' uses
     413                                        # only default tablespace
    370414#check_function_bodies = on
    371415#default_transaction_isolation = 'read committed'
    372416#default_transaction_read_only = off
    373 #statement_timeout = 0                  # 0 is disabled, in milliseconds
     417#session_replication_role = 'origin'
     418#statement_timeout = 0                  # 0 is disabled
     419#vacuum_freeze_min_age = 100000000
     420#xmlbinary = 'base64'
     421#xmloption = 'content'
    374422
    375423# - Locale and Formatting -
    376424
    377 #datestyle = 'iso, mdy'
    378 #timezone = unknown                     # actually, defaults to TZ
    379                                         # environment setting
    380 #australian_timezones = off
     425datestyle = 'iso, mdy'
     426#timezone = unknown                     # actually, defaults to TZ environment
     427                                        # setting
     428#timezone_abbreviations = 'Default'     # Select the set of available time zone
     429                                        # abbreviations.  Currently, there are
     430                                        #   Default
     431                                        #   Australia
     432                                        #   India
     433                                        # You can create your own file in
     434                                        # share/timezonesets/.
    381435#extra_float_digits = 0                 # min -15, max 2
    382436#client_encoding = sql_ascii            # actually, defaults to database
    383437                                        # encoding
    384438
    385 # These settings are initialized by initdb -- they might be changed
    386 lc_messages = 'C'                       # locale for system error message 
     439# These settings are initialized by initdb, but they can be changed.
     440lc_messages = 'C'                       # locale for system error message
    387441                                        # strings
    388442lc_monetary = 'C'                       # locale for monetary formatting
     
    390444lc_time = 'C'                           # locale for time formatting
    391445
     446# default configuration for text search
     447default_text_search_config = 'pg_catalog.english'
     448
    392449# - Other Defaults -
    393450
    394451#explain_pretty_print = on
    395452#dynamic_library_path = '$libdir'
    396 
    397 
    398 #---------------------------------------------------------------------------
     453#local_preload_libraries = ''
     454
     455
     456#------------------------------------------------------------------------------
    399457# LOCK MANAGEMENT
    400 #---------------------------------------------------------------------------
    401 
    402 #deadlock_timeout = 1000                # in milliseconds
     458#------------------------------------------------------------------------------
     459
     460#deadlock_timeout = 1s
    403461#max_locks_per_transaction = 64         # min 10
    404 # note: each lock table slot uses ~220 bytes of shared memory, and there are
     462                                        # (change requires restart)
     463# Note:  Each lock table slot uses ~270 bytes of shared memory, and there are
    405464# max_locks_per_transaction * (max_connections + max_prepared_transactions)
    406465# lock table slots.
    407466
    408467
    409 #---------------------------------------------------------------------------
     468#------------------------------------------------------------------------------
    410469# VERSION/PLATFORM COMPATIBILITY
    411 #---------------------------------------------------------------------------
    412 
    413 # - Previous Postgres Versions -
     470#------------------------------------------------------------------------------
     471
     472# - Previous PostgreSQL Versions -
    414473
    415474#add_missing_from = off
     475#array_nulls = on
    416476#backslash_quote = safe_encoding        # on, off, or safe_encoding
    417477#default_with_oids = off
    418 #escape_string_warning = off
     478#escape_string_warning = on
    419479#regex_flavor = advanced                # advanced, extended, or basic
    420480#sql_inheritance = on
    421 
    422 # - Other Platforms & Clients -
     481#standard_conforming_strings = off
     482#synchronize_seqscans = on
     483
     484# - Other Platforms and Clients -
    423485
    424486#transform_null_equals = off
    425487
    426488
    427 #---------------------------------------------------------------------------
     489#------------------------------------------------------------------------------
    428490# CUSTOMIZED OPTIONS
    429 #---------------------------------------------------------------------------
     491#------------------------------------------------------------------------------
    430492
    431493#custom_variable_classes = ''           # list of custom variable class names
Note: See TracChangeset for help on using the changeset viewer.