Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gRvHZ-0003lv-MV for pgsql-sql@arkaria.postgresql.org; Wed, 28 Nov 2018 08:33:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gRvHY-0002eJ-Hx for pgsql-sql@arkaria.postgresql.org; Wed, 28 Nov 2018 08:33:16 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gRvHX-0002eC-IU for pgsql-sql@lists.postgresql.org; Wed, 28 Nov 2018 08:33:16 +0000 Received: from mail-wm1-x344.google.com ([2a00:1450:4864:20::344]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gRvHS-0006Py-QL for pgsql-sql@postgresql.org; Wed, 28 Nov 2018 08:33:14 +0000 Received: by mail-wm1-x344.google.com with SMTP id s14so1380885wmh.1 for ; Wed, 28 Nov 2018 00:33:10 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=message-id:from:to:subject:date:mime-version:thread-index :content-language; bh=1BNFWlbv/PfBoaq1D0+LXsJ7I4SA8/j46XdBNtJeNMs=; b=jX5EPqc6YZBFnkSdAskm+aIK3mC0iMpmSx7epNIOpMRQ2nDhGzDpGbvVsMtPnbhgSN NZum77l04r8AegSymBi1EZhJfXEXbTHADQRGPLuwteaNzf5fi279hrLZ5DzQkuErfxZV t8DYe67F3+wWsotmT1WjlcHkFsutZfOraPKdFyp+wvO95CHCHu7xjkRiood2PEZiliyT t1i6VlOQaCX8mITrY3HQz6+q4zw4iJJqshzdZXwffllllIfo7qkNpLNzz8H0f0Htcdvh vtfeAXNXACOjESSnwLIfFbU4JG1naK3bxY1VWDh37dFKkNNbc8sYJYyh9kvkZnyWVEzy IaEg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:message-id:from:to:subject:date:mime-version :thread-index:content-language; bh=1BNFWlbv/PfBoaq1D0+LXsJ7I4SA8/j46XdBNtJeNMs=; b=n39rftT/MAXF7+Ku0nBS7/DRKXq+4y9KIeNr2f5JS6B5ViZ0dW7N7eWI9FOBgYGKsa 7v3F/qbtxxy2wMyBW6grr7X0i627TvaU/3kJQXN9L2j4fIBNyoqmYJphhQMai2w9bWzW EmpSydX69DWEykdJWfi3BrrWXEO6dioyzMop6NeHm/4woVsPcJMjvh5hl5g9AUUmZQ0X A0DHyWvyTwR5/15rOBJYAHlPJBd04IO/4Ys3AesdNIl2iXwbYagxjkEO5yL71z1WW8Ur xH5/GkX62JkM+8oYI16zWE7gMz7bZR9haFT570HmXwICRGC6hifX0y5cpBxw2aJPr3WG Mi3Q== X-Gm-Message-State: AA+aEWYJ2jO1l3uqWOU1XdtuVBWGXawbyOFp1FYJH3Wmc1M3oQf7Jgfx QJf+XnVKo8Wi5zHdnPjVS5b7loBo X-Google-Smtp-Source: AFSGD/Ud0J4kYMBQX4v3HsbDWP/xF7KhkPrrLHJqhdImLYhaoipIJjW04AgQS1hG/XFo/JGxWw3VoA== X-Received: by 2002:a1c:b1d5:: with SMTP id a204mr1931585wmf.32.1543393988064; Wed, 28 Nov 2018 00:33:08 -0800 (PST) Received: from PADOUE (mau78-1-88-184-109-217.fbx.proxad.net. [88.184.109.217]) by smtp.gmail.com with ESMTPSA id s139sm3853759wmd.3.2018.11.28.00.33.00 for (version=TLS1 cipher=ECDHE-RSA-AES128-SHA bits=128/128); Wed, 28 Nov 2018 00:33:06 -0800 (PST) Message-ID: <5bfe52c2.1c69fb81.f4ac6.53a6@mx.google.com> X-Google-Original-Message-ID: <02f201d486f4$f8fb2da0$eaf188e0$@lepretre@gmail.com> From: =?iso-8859-1?Q?Olivier_Lepr=EAtre?= To: Subject: error code 8 Date: Wed, 28 Nov 2018 09:32:54 +0100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_02F3_01D486FD.5ABF95A0" X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: AdSG9PNBwzZRrn48QAW3CVtXx59xxg== Content-Language: fr X-Antivirus: Avast (VPS 181127-4, 27/11/2018), Outbound message X-Antivirus-Status: Clean List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. ------=_NextPart_000_02F3_01D486FD.5ABF95A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I get shared "memory exhausted messages". shared buffers where set to 1Gb. = I tried to increase them to 2048 or 1536 and got "error code 8" when trying t= o launch with pg_ctl. Windows server 2016 8 Gb Postgresql 9.6 Below is the postgresql.conf file. Is this shared buffer parameter the main= one to change for shared memory problems ? I read " If you have a system with 1GB or more of RAM, a reasonable startin= g value for shared_buffers is 1/4 of the memory in your system. " https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server But it seems that I can't go above 1gb, even with a 8 Gbytes memory. What does this error code 8 means, it does not appear here https://www.postgresql.org/docs/9.6/errcodes-appendix.html Thanks for any help, Olivier # ----------------------------- # PostgreSQL configuration file # ----------------------------- # # This file consists of lines of the form: # # name =3D value # # (The "=3D" is optional.) Whitespace may be used. Comments are introduce= d 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=3Don". Some parameters can be changed at ru= n time # with the "SET" SQL command. # # Memory units: kB =3D kilobytes Time units: ms =3D milliseconds # MB =3D megabytes s =3D seconds # GB =3D gigabytes min =3D minutes # TB =3D terabytes h =3D hours # d =3D days #--------------------------------------------------------------------------= - --- # FILE LOCATIONS #--------------------------------------------------------------------------= - --- # The default values of these variables are driven from the -D command-line= # option or PGDATA environment variable, represented here as ConfigDir. #data_directory =3D 'ConfigDir' # use data in another directory # (change requires restart= ) #hba_file =3D 'ConfigDir/pg_hba.conf' # host-based authentication fil= e # (change requires restart= ) #ident_file =3D 'ConfigDir/pg_ident.conf' # ident configuration file # (change requires restart= ) # If external_pid_file is not explicitly set, no extra PID file is written.= #external_pid_file =3D '' # write an extra PID fi= le # (change requires restart= ) #--------------------------------------------------------------------------= - --- # CONNECTIONS AND AUTHENTICATION #--------------------------------------------------------------------------= - --- # - Connection Settings - listen_addresses =3D '*' # what IP address(es) to listen on= ; # comma-separated list of addresses; # defaults to 'localhost';= use '*' for all # (change requires restart= ) port =3D 5432 # (change requires restart) max_connections =3D 100 # (change requires restart) #superuser_reserved_connections =3D 3 # (change requires restart) #unix_socket_directories =3D '' # comma-separated list of directories= # (change requires restart= ) #unix_socket_group =3D '' # (change requires restart)= #unix_socket_permissions =3D 0777 # begin with 0 to use octal notation # (change requires restart= ) #bonjour =3D off # advertise server vi= a Bonjour # (change requires restart= ) #bonjour_name =3D '' # defaults to the computer name # (change requires restart= ) # - Security and Authentication - #authentication_timeout =3D 1min # 1s-600s #ssl =3D off # (change requires restart) #ssl_ciphers =3D 'HIGH:MEDIUM:+3DES:!aNULL' # allowed SSL ciphers # (change requires restart= ) #ssl_prefer_server_ciphers =3D on # (change requires restart) #ssl_ecdh_curve =3D 'prime256v1' # (change requires restart) #ssl_cert_file =3D 'server.crt' # (change requires resta= rt) #ssl_key_file =3D 'server.key' # (change requires restart= ) #ssl_ca_file =3D '' # (change requires restart) #ssl_crl_file =3D '' # (change requires restart) #password_encryption =3D on #db_user_namespace =3D off #row_security =3D on # GSSAPI using Kerberos #krb_server_keyfile =3D '' #krb_caseins_users =3D off # - TCP Keepalives - # see "man 7 tcp" for details #tcp_keepalives_idle =3D 0 # TCP_KEEPIDLE, in seconds; # 0 selects the system default #tcp_keepalives_interval =3D 0 # TCP_KEEPINTVL, in seconds;= # 0 selects the system default #tcp_keepalives_count =3D 0 # TCP_KEEPCNT; # 0 selects the system default #--------------------------------------------------------------------------= - --- # RESOURCE USAGE (except WAL) #--------------------------------------------------------------------------= - --- # - Memory - shared_buffers =3D 1024MB # min 128kB # (change requires restart= ) #huge_pages =3D try # on, off, or try # (change requires restart= ) temp_buffers =3D 16MB # min 800kB #max_prepared_transactions =3D 0 # zero disables the feature # (change requires restart= ) # Caution: it is not advisable to set max_prepared_transactions nonzero unless # you actively intend to use prepared transactions. work_mem =3D 64MB # min 64kB/Pr=E9c=E9dent 16= maintenance_work_mem =3D 64MB # min 1MB #replacement_sort_tuples =3D 150000 # limits use of replacement select= ion sort #autovacuum_work_mem =3D -1 # min 1MB, or -1 to use maintenance_work_mem #max_stack_depth =3D 2MB # min 100kB dynamic_shared_memory_type =3D windows # the default is the first opt= ion # supported by the operating system: # posix # sysv # windows # mmap # use none to disable dynamic shared memory # - Disk - #temp_file_limit =3D -1 # limits per-process temp= file space # in kB, or -1 for no limi= t # - Kernel Resource Usage - #max_files_per_process =3D 1000 # min 25 # (change requires restart= ) #shared_preload_libraries =3D '' # (change requires restart) # - Cost-Based Vacuum Delay - #vacuum_cost_delay =3D 0 # 0-100 milliseconds #vacuum_cost_page_hit =3D 1 # 0-10000 credits #vacuum_cost_page_miss =3D 10 # 0-10000 credits #vacuum_cost_page_dirty =3D 20 # 0-10000 credits #vacuum_cost_limit =3D 200 # 1-10000 credits # - Background Writer - #bgwriter_delay =3D 200ms # 10-10000ms between rounds #bgwriter_lru_maxpages =3D 100 # 0-1000 max buffers written/rou= nd #bgwriter_lru_multiplier =3D 2.0 # 0-10.0 multiplier on buffer= s scanned/round #bgwriter_flush_after =3D 0 # 0 disables, # default is 512kB on linux, 0 otherwise # - Asynchronous Behavior - #effective_io_concurrency =3D 0 # 1-1000; 0 disables prefetch= ing #max_worker_processes =3D 8 # (change requires restart) #max_parallel_workers_per_gather =3D 0 # taken from max_worker_processes #old_snapshot_threshold =3D -1 # 1min-60d; -1 disables; 0 is immediate # (change requires restart) #backend_flush_after =3D 0 # 0 disables, default is 0 #--------------------------------------------------------------------------= - --- # WRITE AHEAD LOG #--------------------------------------------------------------------------= - --- # - Settings - #wal_level =3D minimal # minimal, replica, or logical # (change requires restart= ) #fsync =3D on # flush data to disk for crash= safety # (turning this off can cause # unrecoverable data corruption) #synchronous_commit =3D on # synchronization level; # off, local, remote_write= , remote_apply, or on #wal_sync_method =3D fsync # the default is the first opt= ion # supported by the operating system: # open_datasync # fdatasync (default on Linux) # fsync # fsync_writethrough # open_sync #full_page_writes =3D on # recover from partial pag= e writes #wal_compression =3D off # enable compression of full-page writes #wal_log_hints =3D off # also do full page writ= es of non-critical updates # (change requires restart= ) #wal_buffers =3D -1 # min 32kB, -1 sets based on shared_buffers # (change requires restart= ) #wal_writer_delay =3D 200ms # 1-10000 milliseconds #wal_writer_flush_after =3D 1MB # 0 disables #commit_delay =3D 0 # range 0-100000, in microseconds #commit_siblings =3D 5 # range 1-1000 # - Checkpoints - #checkpoint_timeout =3D 5min # range 30s-1d #max_wal_size =3D 1GB #min_wal_size =3D 80MB #checkpoint_completion_target =3D 0.5 # checkpoint target duration, 0.0 = - 1.0 #checkpoint_flush_after =3D 0 # 0 disables, # default is 256kB on linux, 0 otherwise #checkpoint_warning =3D 30s # 0 disables # - Archiving - #archive_mode =3D off # enables archiving; off, on, or always # (change requires restart) #archive_command =3D '' # command to use to archive a logfile= segment # placeholders: %p =3D path of file = to archive # %f =3D file name onl= y # e.g. 'test ! -f /mnt/server/archivedir/%f && cp %p /mnt/server/archivedir/%f' #archive_timeout =3D 0 # force a logfile segment switch aft= er 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 =3D 0 # max number of walsender processes # (change requires restart) #wal_keep_segments =3D 0 # in logfile segments, 16MB each; 0 disables #wal_sender_timeout =3D 60s # in milliseconds; 0 disables #max_replication_slots =3D 0 # max number of replication slots # (change requires restart) #track_commit_timestamp =3D off # collect timestamp of transaction commit # (change requires restart) # - Master Server - # These settings are ignored on a standby server. #synchronous_standby_names =3D '' # standby servers that provide syn= c rep # number of sync standbys and comma-separated list of application_name # from standby(s); '*' =3D all #vacuum_defer_cleanup_age =3D 0 # number of xacts by which cleanup= is delayed # - Standby Servers - # These settings are ignored on a master server. #hot_standby =3D off # "on" allows queries during recov= ery # (change requires restart= ) #max_standby_archive_delay =3D 30s # max delay before canceling querie= s # when reading WAL from archive; # -1 allows indefinite delay #max_standby_streaming_delay =3D 30s # max delay before canceling queries # when reading streaming WAL; # -1 allows indefinite delay #wal_receiver_status_interval =3D 10s # send replies at least this oft= en # 0 disables #hot_standby_feedback =3D off # send info from standby to prevent # query conflicts #wal_receiver_timeout =3D 60s # time that receiver waits for= # communication from maste= r # in milliseconds; 0 disables #wal_retrieve_retry_interval =3D 5s # time to wait before retrying= to # retrieve WAL after a failed attempt #--------------------------------------------------------------------------= - --- # QUERY TUNING #--------------------------------------------------------------------------= - --- # - Planner Method Configuration - #enable_bitmapscan =3D on #enable_hashagg =3D on #enable_hashjoin =3D on #enable_indexscan =3D on #enable_indexonlyscan =3D on #enable_material =3D on #enable_mergejoin =3D on #enable_nestloop =3D on #enable_seqscan =3D on #enable_sort =3D on #enable_tidscan =3D on # - Planner Cost Constants - #seq_page_cost =3D 1.0 # measured on an arbitrary scale #random_page_cost =3D 4.0 # same scale as above #cpu_tuple_cost =3D 0.01 # same scale as above #cpu_index_tuple_cost =3D 0.005 # same scale as above #cpu_operator_cost =3D 0.0025 # same scale as above #parallel_tuple_cost =3D 0.1 # same scale as above #parallel_setup_cost =3D 1000.0 # same scale as above #min_parallel_relation_size =3D 8MB #effective_cache_size =3D 4GB # - Genetic Query Optimizer - #geqo =3D on #geqo_threshold =3D 12 #geqo_effort =3D 5 # range 1-10 #geqo_pool_size =3D 0 # selects default based on= effort #geqo_generations =3D 0 # selects default based on effort #geqo_selection_bias =3D 2.0 # range 1.5-2.0 #geqo_seed =3D 0.0 # range 0.0-1.0 # - Other Planner Options - #default_statistics_target =3D 100 # range 1-10000 #constraint_exclusion =3D partition # on, off, or partition #cursor_tuple_fraction =3D 0.1 # range 0.0-1.0 #from_collapse_limit =3D 8 #join_collapse_limit =3D 8 # 1 disables collapsing of explicit= # JOIN clauses #force_parallel_mode =3D off #--------------------------------------------------------------------------= - --- # ERROR REPORTING AND LOGGING #--------------------------------------------------------------------------= - --- # - Where to Log - log_destination =3D 'stderr' # Valid values are combinations of= # stderr, csvlog, syslog, and eventlog, # depending on platform. csvlog # requires logging_collector to be on. # This is used when logging to stderr: logging_collector =3D on # Enable capturing of stderr and csvlog # into log files. Required= to be on for # csvlogs. # (change requires restart= ) # These are only used if logging_collector is on: #log_directory =3D 'pg_log' # directory where log files are written, # can be absolute or relative to PGDATA #log_filename =3D 'postgresql-%Y-%m-%d_%H%M%S.log' # log file name pattern, # can include strftime() escapes #log_file_mode =3D 0600 # creation mode for log fil= es, # begin with 0 to use octa= l notation #log_truncate_on_rotation =3D off # If on, an existing log file with the # same name as the new log= file will be # truncated rather than appended to. # But such truncation only= occurs on # time-driven rotation, no= t on restarts # or size-driven rotation.= Default is # off, meaning append to existing files # in all cases. #log_rotation_age =3D 1d # Automatic rotation of logfiles will # happen after that time. 0 disables. #log_rotation_size =3D 10MB # Automatic rotation of logfiles will # happen after that much log output. # 0 disables. # These are relevant when logging to syslog: #syslog_facility =3D 'LOCAL0' #syslog_ident =3D 'postgres' #syslog_sequence_numbers =3D on #syslog_split_messages =3D on # This is only relevant when logging to eventlog (win32): #event_source =3D 'PostgreSQL' # - When to Log - #client_min_messages =3D notice # values in order of decreasing= detail: # debug5 # debug4 # debug3 # debug2 # debug1 # log # notice # warning # error #log_min_messages =3D warning # values in order of decreasing detail: # debug5 # debug4 # debug3 # debug2 # debug1 # info # notice # warning # error # log # fatal # panic #log_min_error_statement =3D error # values in order of decreasing detail: # debug5 # debug4 # debug3 # debug2 # debug1 # info # notice # warning # error # log # fatal # panic (effectively off= ) #log_min_duration_statement =3D -1 # -1 is disabled, 0 logs all statements # and their durations, > 0= logs only # statements running at least this number # of milliseconds # - What to Log - #debug_print_parse =3D off #debug_print_rewritten =3D off #debug_print_plan =3D off #debug_pretty_print =3D on #log_checkpoints =3D off #log_connections =3D off #log_disconnections =3D off #log_duration =3D off #log_error_verbosity =3D default # terse, default, or verbose messages #log_hostname =3D off log_line_prefix =3D '%t ' # special values: # %a =3D application nam= e # %u =3D user name # %d =3D database name # %r =3D remote host and= port # %h =3D remote host # %p =3D process ID # %t =3D timestamp witho= ut milliseconds # %m =3D timestamp with milliseconds # %n =3D timestamp with milliseconds (as a Unix epoch) # %i =3D command tag # %e =3D SQL state # %c =3D session ID # %l =3D session line number # %s =3D session start timestamp # %v =3D virtual transaction ID # %x =3D transaction ID = (0 if none) # %q =3D stop here in non-session # processes # %% =3D '%' # e.g. '<%u%%%d> ' #log_lock_waits =3D off # log lock waits >=3D deadlock_timeout #log_statement =3D 'none' # none, ddl, mod, all #log_replication_commands =3D off #log_temp_files =3D -1 # log temporary files equ= al or larger # than the specified size in kilobytes; # -1 disables, 0 logs all temp files log_timezone =3D 'Europe/Brussels' # - Process Title - #cluster_name =3D '' # added to process titles if nonem= pty # (change requires restart= ) #update_process_title =3D off #--------------------------------------------------------------------------= - --- # RUNTIME STATISTICS #--------------------------------------------------------------------------= - --- # - Query/Index Statistics Collector - #track_activities =3D on #track_counts =3D on #track_io_timing =3D off #track_functions =3D none # none, pl, all #track_activity_query_size =3D 1024 # (change requires restart) #stats_temp_directory =3D 'pg_stat_tmp' # - Statistics Monitoring - #log_parser_stats =3D off #log_planner_stats =3D off #log_executor_stats =3D off #log_statement_stats =3D off #--------------------------------------------------------------------------= - --- # AUTOVACUUM PARAMETERS #--------------------------------------------------------------------------= - --- #autovacuum =3D on # Enable autovacuum subprocess? 'on= ' # requires track_counts to= also be on. #log_autovacuum_min_duration =3D -1 # -1 disables, 0 logs all actions an= d # their durations, > 0 log= s only # actions running at least= this number # of milliseconds. #autovacuum_max_workers =3D 3 # max number of autovacuum subprocesses # (change requires restart= ) #autovacuum_naptime =3D 1min # time between autovacuum runs #autovacuum_vacuum_threshold =3D 50 # min number of row updates before # vacuum #autovacuum_analyze_threshold =3D 50 # min number of row updates before # analyze #autovacuum_vacuum_scale_factor =3D 0.2 # fraction of table size bef= ore vacuum #autovacuum_analyze_scale_factor =3D 0.1 # fraction of table size before analyze #autovacuum_freeze_max_age =3D 200000000 # maximum XID age before forced vacuum # (change requires restart= ) #autovacuum_multixact_freeze_max_age =3D 400000000 # maximum multixac= t age # before forced vacuum # (change requires restart= ) #autovacuum_vacuum_cost_delay =3D 20ms # default vacuum cost delay for= # autovacuum, in milliseconds; # -1 means use vacuum_cost_delay #autovacuum_vacuum_cost_limit =3D -1 # default vacuum cost limit for # autovacuum, -1 means use= # vacuum_cost_limit #--------------------------------------------------------------------------= - --- # CLIENT CONNECTION DEFAULTS #--------------------------------------------------------------------------= - --- # - Statement Behavior - #search_path =3D '"$user", public' # schema names #default_tablespace =3D '' # a tablespace name, '' uses the default #temp_tablespaces =3D '' # a list of tablespace nam= es, '' uses # only default tablespace #check_function_bodies =3D on #default_transaction_isolation =3D 'read committed' #default_transaction_read_only =3D off #default_transaction_deferrable =3D off #session_replication_role =3D 'origin' #statement_timeout =3D 0 # in milliseconds, 0 is disabled #lock_timeout =3D 0 # in milliseconds, 0 is disabled #idle_in_transaction_session_timeout =3D 0 # in millisecond= s, 0 is disabled #vacuum_freeze_min_age =3D 50000000 #vacuum_freeze_table_age =3D 150000000 #vacuum_multixact_freeze_min_age =3D 5000000 #vacuum_multixact_freeze_table_age =3D 150000000 #bytea_output =3D 'hex' # hex, escape #xmlbinary =3D 'base64' #xmloption =3D 'content' #gin_fuzzy_search_limit =3D 0 #gin_pending_list_limit =3D 4MB # - Locale and Formatting - datestyle =3D 'iso, dmy' #intervalstyle =3D 'postgres' timezone =3D 'Europe/Brussels' #timezone_abbreviations =3D 'Default' # Select the set of available tim= e zone # abbreviations. Currently, there are # Default # Australia (historical usage) # India # You can create your own file in # share/timezonesets/. #extra_float_digits =3D 0 # min -15, max 3 #client_encoding =3D sql_ascii # actually, defaults to database # encoding # These settings are initialized by initdb, but they can be changed. lc_messages =3D 'French_France.1252' # locale for system error message # strings lc_monetary =3D 'French_France.1252' # locale for monetary formatting lc_numeric =3D 'French_France.1252' # locale for= number formatting lc_time =3D 'French_France.1252' # locale f= or time formatting # default configuration for text search default_text_search_config =3D 'pg_catalog.french' # - Other Defaults - #dynamic_library_path =3D '$libdir' #local_preload_libraries =3D '' #session_preload_libraries =3D '' #--------------------------------------------------------------------------= - --- # LOCK MANAGEMENT #--------------------------------------------------------------------------= - --- #deadlock_timeout =3D 1s #max_locks_per_transaction =3D 64 # min 10 # (change requires restart= ) #max_pred_locks_per_transaction =3D 64 # min 10 # (change requires restart= ) #--------------------------------------------------------------------------= - --- # VERSION/PLATFORM COMPATIBILITY #--------------------------------------------------------------------------= - --- # - Previous PostgreSQL Versions - #array_nulls =3D on #backslash_quote =3D safe_encoding # on, off, or safe_encoding #default_with_oids =3D off #escape_string_warning =3D on #lo_compat_privileges =3D off #operator_precedence_warning =3D off #quote_all_identifiers =3D off #sql_inheritance =3D on #standard_conforming_strings =3D on #synchronize_seqscans =3D on # - Other Platforms and Clients - #transform_null_equals =3D off #--------------------------------------------------------------------------= - --- # ERROR HANDLING #--------------------------------------------------------------------------= - --- #exit_on_error =3D off # terminate session on a= ny error? #restart_after_crash =3D on # reinitialize after backend crash? #--------------------------------------------------------------------------= - --- # CONFIG FILE INCLUDES #--------------------------------------------------------------------------= - --- # These options allow settings to be loaded from files other than the # default postgresql.conf. #include_dir =3D 'conf.d' # include files ending i= n '.conf' from # directory 'conf.d' #include_if_exists =3D 'exists.conf' # include file only if it exists #include =3D 'special.conf' # include file #--------------------------------------------------------------------------= - --- # CUSTOMIZED OPTIONS #--------------------------------------------------------------------------= - --- # Add settings for extensions here --- L'absence de virus dans ce courrier =E9lectronique a =E9t=E9 v=E9rifi=E9e p= ar le logiciel antivirus Avast. https://www.avast.com/antivirus ------=_NextPart_000_02F3_01D486FD.5ABF95A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi,

 

I get shared "memory exhausted messages". sha= red buffers where set to 1Gb. I tried to increase them to 2048 or 1536 and = got "error code 8" when trying to launch with pg_ctl.<= /span>

 

Windows server 2016 8 Gb

Postgresql 9.6

 

Below is the = postgresql.conf file. Is this shared buffer parameter the main one to chang= e for shared memory problems ?

<= span lang=3DEN-US style=3D'font-size:10.0pt;font-family:"Verdana","sans-ser= if"'> 

I read " If you have a system with 1GB or more= of RAM, a reasonable starting value for shared_buffers is 1/4 of the memor= y in your system. "

https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server

 =

But it seems that I can't go above 1gb, even= with a 8 Gbytes memory.

<= o:p> 

What does this error = code 8 means, it does not appear here

https://www.postgresql.org/docs/9.6/errcodes-appendix.html

 

Thanks for any help,

 

O= livier

 <= /span>

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

# PostgreSQL configuration file

# --------------------------= ---

#

=

# This file consists of lines of the form:<= /o:p>

#

#=A0=A0 name =3D value

#

# (The &qu= ot;=3D" is optional.)=A0 Whitespace may be used.=A0 Comments are intro= duced with

# "#" = anywhere on a line.=A0 The complete list of parameter names and allowed

# values can be found in the P= ostgreSQL documentation.

#<= o:p>

# The commented-out setting= s shown in this file represent the default values.

# Re-commenting a setting is NOT sufficient to reve= rt it to the default value;

# you need to reload the server.

#

# This file is rea= d on server startup and when the server receives a SIGHUP=

# signal.=A0 If you edit the file on a runni= ng system, you have to SIGHUP the

# server for the changes to take effect, or use "pg_ctl reload&= quot;.=A0 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=3Don".=A0 Some parameters can be changed at run time=

# with the "SET"= SQL command.

#<= /span>

# Memory units:=A0 kB =3D kilobytes=A0= =A0=A0=A0=A0=A0=A0 Time units:=A0 ms=A0 =3D milliseconds<= /p>

#=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0 MB =3D megabytes=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0 s=A0=A0 =3D seconds

= #=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 GB =3D gigabytes=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 min =3D minutes=

#=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0 TB =3D terabytes=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0 h=A0=A0 =3D hours

#=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0 d=A0=A0 =3D days

 

 

#------------------------------------------= ------------------------------------

# FILE LOCATIONS

= #--------------------------------------------------------------------------= ----

 

# The default values of these variables ar= e driven from the -D command-line

# option or PGDATA environment variable, represented here as ConfigD= ir.

 

#data_directory =3D 'ConfigDir'=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # use data in another directory

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # (change requires restart)=

#hba_file =3D 'ConfigDir/pg_hba.conf'= =A0=A0=A0=A0=A0=A0 # host-based authentication file

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0 # (change requires restart)

#ident_file =3D 'ConfigDir/pg_ident.conf'=A0=A0 # id= ent configuration file

=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # (chang= e requires restart)

&n= bsp;

# If external_pid_file is n= ot explicitly set, no extra PID file is written.

#external_pid_file =3D ''=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # write an extra PID fi= le

=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # (change requires restart)

 

=

 

#-------------------------------------------------------------------= -----------

# CONNECTIONS A= ND AUTHENTICATION

#--------= ----------------------------------------------------------------------=

 

# - Connection Settings -

 

listen_addresses =3D '*'=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= # what IP address(es) to listen on;

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0 # comma-separated list of addresses;

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0 # defaults to 'localhost'; use '*' for all

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0 # (change requires restart)

port =3D 5432=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # (change requ= ires restart)

max_connectio= ns =3D 100=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0 # (change requires restart)

#superuser_reserved_connections =3D 3=A0=A0 # (change requires rest= art)

#unix_socket_directori= es =3D ''=A0=A0=A0=A0=A0=A0 # comma-separated list of directories

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # (change requires restart)

#unix_socket_group =3D ''=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # (change requires rest= art)

#unix_socket_permissio= ns =3D 0777=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # begin w= ith 0 to use octal notation

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # = (change requires restart)

#= bonjour =3D off=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # advertise server via = Bonjour

=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # (change requires rest= art)

#bonjour_name =3D ''= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # defaults to the= computer name

=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # (change require= s restart)

 

# - Security and Authentication -

 

<= p class=3DMsoNormal>#authentication_timeout =3D 1min=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0 # 1s-600s

#= ssl =3D off=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # (change requires restart)

#ssl_ciphers =3D 'HIGH:MEDIUM:+3= DES:!aNULL' # allowed SSL ciphers

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0 # (change requires restart)

<= span lang=3DEN-US style=3D'font-size:10.0pt;font-family:"Verdana","sans-ser= if"'>#ssl_prefer_server_ciphers =3D on=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # (= change requires restart)

#s= sl_ecdh_curve =3D 'prime256v1'=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # (change requ= ires restart)

#ssl_cert_fil= e =3D 'server.crt'=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= # (change requires restart)

#ssl_key_file =3D 'server.key'=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0 # (change requires restart)

#ssl_ca_file =3D ''=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # (change requires restart)

#ssl_crl_file =3D ''=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # (change require= s restart)

#password_encryp= tion =3D on

#db_user_namesp= ace =3D off

#row_security = =3D on

 <= /span>

# GSSAPI using Kerberos

#krb_server_keyfile =3D ''

#krb_caseins_users =3D off

 

# - TCP Keepalives -

# see "man 7 tcp" for details

 

#tcp_keepalives_idle =3D 0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # TCP_KEEPIDLE= , in seconds;

=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # 0 selects the s= ystem default

#tcp_keepaliv= es_interval =3D 0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # TCP_KEE= PINTVL, in seconds;

=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # 0 selects= the system default

#tcp_ke= epalives_count =3D 0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 = # TCP_KEEPCNT;

=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # 0 selects the s= ystem default

 

 

#----------------------------------------------------= --------------------------

= # RESOURCE USAGE (except WAL)

#-----------------------------------------------------------------------= -------

 <= /span>

# - Memory -

 

shared_buffers =3D 1024MB=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0 # min 128kB

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= # (change requires restart)

#huge_pages =3D try=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0 # on, off, or try

= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # (ch= ange requires restart)

temp= _buffers =3D 16MB=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0 # min 800kB

#max_prepared_transactions =3D 0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # zero d= isables the feature

=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # (change r= equires restart)

# Caution:= it is not advisable to set max_prepared_transactions nonzero unless

# you actively intend to use prep= ared transactions.

work_mem= =3D 64MB=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0 # min 64kB/Pr=E9c=E9dent 16

<= p class=3DMsoNormal>maintenance_work_mem =3D 64MB=A0=A0=A0=A0=A0=A0= =A0=A0=A0 # min 1MB

#replac= ement_sort_tuples =3D 150000=A0=A0=A0=A0=A0 # limits use of replacement sel= ection sort

#autovacuum_wor= k_mem =3D -1=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # min 1MB, or -1 to use= maintenance_work_mem

#max= _stack_depth =3D 2MB=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0 # min 100kB

dynamic_= shared_memory_type =3D windows=A0=A0=A0=A0=A0=A0 # the default is the first= option

=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # supported by the oper= ating system:

=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 #=A0=A0 posix

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 #=A0=A0 sysv

<= p class=3DMsoNormal>=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0 #=A0=A0 windows

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0 #=A0=A0 mmap

=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # use none = to disable dynamic shared memory

=  

# - Disk -

 

#temp_file_limit =3D -1=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # limits per-process te= mp file space

=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # in kB, or -1 fo= r no limit

 

# - Kernel Resource Usage -

 

#max_files_per_process =3D 1000=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0 # min 25

=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # (change r= equires restart)

#shared_pr= eload_libraries =3D ''=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # (change = requires restart)

&nbs= p;

# - Cost-Based Vacuum Delay -=

 

#vacuum_cost_delay =3D 0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # 0-100 milliseconds<= /span>

#vacuum_cost_page_hit =3D 1=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # 0-10000 credits=

#vacuum_cost_page_miss =3D 10=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0 # 0-10000 credits

#vacuum_cost_page_dirty =3D 20=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 #= 0-10000 credits

#vacuum_co= st_limit =3D 200=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 #= 1-10000 credits

 = ;

# - Background Writer -

 

#bgwriter_delay =3D 200ms=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # 10-10000ms between rounds

#bgwriter_lru_maxpages =3D 100=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0 # 0-1000 max buffers written/round

#bgwriter_lru_multiplier =3D 2.0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # 0-10.0 multiplier on buffers scanned/ro= und

#bgwriter_flush_after = =3D 0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # 0 disables,

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0 # default is 512kB on linux, 0 otherwise

 

# - Asynchronous Behavior -

 

#eff= ective_io_concurrency =3D 0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # 1-1= 000; 0 disables prefetching

#max_worker_processes =3D 8=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0 # (change requires restart)

<= span lang=3DEN-US style=3D'font-size:10.0pt;font-family:"Verdana","sans-ser= if"'>#max_parallel_workers_per_gather =3D 0 # taken from max_worker_process= es

#old_snapshot_threshold = =3D -1=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # 1min-60d; -1 disables; 0= is immediate

=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0 # (change requires restart)

#backend_flush_after =3D 0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0 # 0 disables, default is 0

 

&n= bsp;

#--------------------------= ----------------------------------------------------

<= p class=3DMsoNormal># WRITE AHEAD LOG

#-------------------------------------------------------= -----------------------

 

# - Settings -

 

#wal_level =3D minimal=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # minimal, replica, or logica= l

=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # (change requires restart)

#fsync =3D on=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0 # flush data to disk for crash safety

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # (turning this off can cause<= /o:p>

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # unr= ecoverable data corruption)

#synchronous_commit =3D on=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0 # synchronization level;

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # = off, local, remote_write, remote_apply, or on

#wal_sync_method =3D fsync=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0 # the default is the first option

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0 # supported by the operating system:=

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 #=A0=A0 open_datasync

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0 #=A0=A0 fdatasync (default on Linux)

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 #=A0=A0 fsync

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0 #=A0=A0 fsync_writethrough

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0 #=A0=A0 open_sync

#full_page_writes =3D on=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0 # recover from partial page writes

#wal_compression =3D off=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # enable compression= of full-page writes

#wal= _log_hints =3D off=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0 # also do full page writes of non-critical upda= tes

=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # (change requires restart= )

#wal_buffers =3D -1=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # min 32kB, -1= sets based on shared_buffers

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # = (change requires restart)

#= wal_writer_delay =3D 200ms=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0 # 1-10000 milliseconds

= #wal_writer_flush_after =3D 1MB=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # 0 = disables

 <= /span>

#commit_delay =3D 0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # range 0-100000, in microseconds

#commit_siblings =3D 5=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # = range 1-1000

 

# - Checkpoints -

 

#checkpoint_timeout =3D 5min=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0 # range 30s-1d

#max_wal_size =3D 1GB

#= min_wal_size =3D 80MB

#che= ckpoint_completion_target =3D 0.5=A0=A0=A0 # checkpoint target duration, 0.= 0 - 1.0

#checkpoint_flush_= after =3D 0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # 0 disables= ,

=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # default is 256kB on linux, = 0 otherwise

#checkpoint_war= ning =3D 30s=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # 0 disable= s

 <= /p>

# - Archiving -

 

#= archive_mode =3D off=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 = # enables archiving; off, on, or always

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # (change requires r= estart)

#archive_command = =3D ''=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # command to use to archiv= e a logfile segment

=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # placeholders: %p =3D path of file to ar= chive

=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0 #=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 %f =3D file = name only

=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0 # e.g. 'test ! -f /mnt/server/archivedir/%f &&= amp; cp %p /mnt/server/archivedir/%f'

#archive_timeout =3D 0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0 # force a logfile segment switch after this

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # number of= seconds; 0 disables

 

 =

#-------------------------------------------= -----------------------------------

# REPLICATION

#---= ---------------------------------------------------------------------------=

 

# - Sending Server(s) -

<= p class=3DMsoNormal> 

= # Set these on the master and on any standby that will send replicati= on data.

 <= /span>

#max_wal_senders =3D 0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0 # max number of walsender processes<= /span>

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0 # (change requires restart)

<= span lang=3DEN-US style=3D'font-size:10.0pt;font-family:"Verdana","sans-ser= if"'>#wal_keep_segments =3D 0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # in logfile se= gments, 16MB each; 0 disables

#wal_sender_timeout =3D 60s=A0=A0=A0=A0=A0=A0=A0 # in milliseconds; 0 di= sables

 <= /span>

#max_replication_slots =3D 0=A0=A0=A0= =A0=A0=A0=A0=A0 # max number of replication slots

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # (change r= equires restart)

#track_com= mit_timestamp =3D off=A0 # collect timestamp of transaction commit

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0 # (change requires restart)

 

# - Master S= erver -

 <= /span>

# These settings are ignored on a stan= dby server.

 

#synchronous_standby_names =3D ''= =A0=A0=A0=A0=A0=A0=A0 # standby servers that provide sync rep

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= # number of sync standbys and comma-separated list of application_name

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0 # from standby(s); '*' =3D all

#vacuum_defer_cleanup_age =3D 0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # = number of xacts by which cleanup is delayed

 

#= - Standby Servers -

 

# These settings are ign= ored on a master server.

 

#hot_standby =3D off= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # "on&quo= t; allows queries during recovery

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0 # (change requires restart)

<= span lang=3DEN-US style=3D'font-size:10.0pt;font-family:"Verdana","sans-ser= if"'>#max_standby_archive_delay =3D 30s=A0=A0=A0=A0=A0 # max delay before c= anceling queries

=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # when reading= WAL from archive;

=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # -1 allows= indefinite delay

#max_stan= dby_streaming_delay =3D 30s=A0 # max delay before canceling queries

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # when reading streaming WAL;<= /o:p>

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # -1 allows indefinite delay

#wal_receiver_status_interval =3D= 10s=A0=A0=A0=A0=A0 # send replies at least this often

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0 # 0 disables

#hot_standby_feedback =3D off=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0 # send info from standby to prevent

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0 # query conflicts

#wal_receiver_timeout =3D 60s=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0 # time that receiver waits for

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0 # communication from master

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0 # in milliseconds; 0 disables

#wal_retrieve_retry_interval =3D 5s=A0=A0=A0=A0=A0=A0=A0=A0=A0 # = time to wait before retrying to

<= span lang=3DEN-US style=3D'font-size:10.0pt;font-family:"Verdana","sans-ser= if"'>=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= # retrieve WAL after a failed attempt

 

&nb= sp;

#---------------------------= ---------------------------------------------------

# QUERY TUNING

#-------------------------------------------------------------= -----------------

&nbs= p;

# - Planner Method Configurat= ion -

 

#enable_bitmapscan =3D on

#enable_hashagg =3D on

#enable_hashjoin =3D on

<= p class=3DMsoNormal>#enable_indexscan =3D on

#enable_indexonlyscan =3D on

<= p class=3DMsoNormal>#enable_material =3D on

#enable_mergejoin =3D on

#enable_nestloop =3D on

#enable_seqscan =3D on

#enable_sort =3D on

#enable_tidscan =3D on

 

# - Planner Cost= Constants -

 

#seq_page_cost =3D 1.0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # measur= ed on an arbitrary scale

#r= andom_page_cost =3D 4.0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0 # same scale as above

#cpu_tuple_cost =3D 0.01=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0 # same scale as above

#cpu_index_tuple_cost =3D 0.005=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0 # same scale as above

<= span lang=3DEN-US style=3D'font-size:10.0pt;font-family:"Verdana","sans-ser= if"'>#cpu_operator_cost =3D 0.0025=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0 # same scale as above

#parallel_tuple_cost =3D 0.1=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # same scale a= s above

#parallel_setup_co= st =3D 1000.0=A0=A0=A0 # same scale as above

#min_parallel_relation_size =3D 8MB

#effective_cache_size =3D 4GB=

 

# - Genetic Query Optimizer -

 

#geq= o =3D on

#geqo_threshold = =3D 12

#geqo_effort =3D 5= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # ran= ge 1-10

#geqo_pool_size = =3D 0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0 # selects default based on effort

#geqo_generations =3D 0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # selects default based on effor= t

#geqo_selection_bias =3D = 2.0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # range 1.5-2.0

#geqo_seed =3D 0.0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # range 0.0-1.0=

 

# - Other Planner Options -

 

<= span lang=3DEN-US style=3D'font-size:10.0pt;font-family:"Verdana","sans-ser= if"'>#default_statistics_target =3D 100=A0 # range 1-10000

#constraint_exclusion =3D partition # on, o= ff, or partition

#cursor_tu= ple_fraction =3D 0.1=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # rang= e 0.0-1.0

#from_collapse_li= mit =3D 8

#join_collapse_li= mit =3D 8=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # 1 disables collapsing of= explicit

=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # JOIN clauses<= /o:p>

#force_parallel_mode =3D off

 

 

<= span lang=3DEN-US style=3D'font-size:10.0pt;font-family:"Verdana","sans-ser= if"'>#---------------------------------------------------------------------= ---------

# ERROR REPORTING= AND LOGGING

#-------------= -----------------------------------------------------------------

 

# - Where to Log -

 

log_desti= nation =3D 'stderr'=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # Valid values are = combinations of

=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # stderr, csvl= og, syslog, and eventlog,

= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # dep= ending on platform.=A0 csvlog

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # = requires logging_collector to be on.

 

# This is = used when logging to stderr:

logging_collector =3D on=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 = # Enable capturing of stderr and csvlog

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0 # into log files. Required to be on for

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0 # csvlogs.

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # = (change requires restart)

<= o:p> 

# These are only used= if logging_collector is on:

#log_directory =3D 'pg_log'=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # directory = where log files are written,

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # = can be absolute or relative to PGDATA

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

=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # can in= clude strftime() escapes

#l= og_file_mode =3D 0600=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0 # creation mode for log files,

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0 # begin with 0 to use octal notation

#log_truncate_on_rotation =3D off=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0 # If on, an existing log file with the

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # same name as the new log file will be=

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # truncated rather than appended to= =2E

=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # But such truncation only= occurs on

=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # time-driven rotati= on, not on restarts

=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # or size-d= riven rotation.=A0 Default is

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # = off, meaning append to existing files

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0 # in all cases.

#log= _rotation_age =3D 1d=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0 # Automatic rotation of logfiles will

=

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0 # happen after that time.=A0 0 disables.

#log_rotation_size =3D 10MB=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # Automatic rotation of logfi= les will

=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # happen after that muc= h log output.

=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # 0 disables.

 

# These are relevant when logging to syslog:<= /o:p>

#syslog_facility =3D 'LOCAL0'

#syslog_ident =3D 'postgres'<= o:p>

#syslog_sequence_numbers = =3D on

#syslog_split_mess= ages =3D on

 

# This is only relevant when loggin= g to eventlog (win32):

#eve= nt_source =3D 'PostgreSQL'

=  

# - When to Log -<= o:p>

 

#client_min_messages =3D notice=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0 # values in order of decreasing detail:

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 #=A0=A0 debug5

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0 #=A0=A0 debug4

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= #=A0=A0 debug3

=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 #=A0=A0 debug2=

=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 #=A0=A0 debug1

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 #=A0=A0 log

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0 #=A0=A0 notice

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 #= =A0=A0 warning

=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 #=A0=A0 error

 

#log_min_messages =3D warning=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0 # values in order of decreasing detail:

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0 #=A0=A0 debug5

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0 #=A0=A0 debug4

= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 #=A0= =A0 debug3

=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 #=A0=A0 debug2<= /o:p>

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 #=A0=A0 debug1

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0 #=A0=A0 info

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0 #=A0=A0 notice

=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 #=A0=A0 = warning

=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 #=A0=A0 error

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 #=A0=A0 log

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0 #=A0=A0 fatal

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 #= =A0=A0 panic

 

#log_min_error_statement =3D err= or=A0=A0=A0=A0=A0=A0=A0=A0 # values in order of decreasing detail:

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 #=A0=A0 debug5

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0 #=A0=A0 debug4

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0 #=A0=A0 debug3

=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 #=A0=A0 = debug2

=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 #=A0=A0 debug1

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 #=A0=A0 info

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0 #=A0=A0 notice

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0 #=A0=A0 warning

=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 #=A0=A0 err= or

=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 #=A0=A0 log=

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0 #=A0=A0 fatal

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0 #=A0=A0 panic (effectively off)

 

#log= _min_duration_statement =3D -1=A0=A0=A0=A0=A0=A0 # -1 is disabled, 0 logs a= ll statements

=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # and their durat= ions, > 0 logs only

=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # statem= ents running at least this number

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0 # of milliseconds

 

 =

# - What to Log -

 

#debug_print_parse =3D off

#debug_print_rewritten =3D off

= #debug_print_plan =3D off

<= span lang=3DEN-US style=3D'font-size:10.0pt;font-family:"Verdana","sans-ser= if"'>#debug_pretty_print =3D on

<= span lang=3DEN-US style=3D'font-size:10.0pt;font-family:"Verdana","sans-ser= if"'>#log_checkpoints =3D off

#log_connections =3D off

#log_disconnections =3D off

#log_duration =3D off

#lo= g_error_verbosity =3D default=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # ters= e, default, or verbose messages

<= span lang=3DEN-US style=3D'font-size:10.0pt;font-family:"Verdana","sans-ser= if"'>#log_hostname =3D off

= log_line_prefix =3D '%t '=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # special values:

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0 #=A0=A0 %a =3D application name

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0 #=A0=A0 %u =3D user name

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0 #=A0=A0 %d =3D database name

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0 #=A0=A0 %r =3D remote host and port

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0 #=A0=A0 %h =3D remote host

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0 #=A0=A0 %p =3D process ID

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0 #=A0=A0 %t =3D timestamp without milliseconds

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 #=A0=A0 %m =3D timestamp with milliseconds

=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 #=A0=A0 %n =3D timestamp with mi= lliseconds (as a Unix epoch)

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 #= =A0=A0 %i =3D command tag

= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 #=A0= =A0 %e =3D SQL state

=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 #=A0=A0 = %c =3D session ID

=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 #=A0=A0 %l =3D= session line number

=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 #=A0=A0 = %s =3D session start timestamp

=A0=A0=A0=A0=A0=A0=A0=A0=A0 =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 #= =A0=A0 %v =3D virtual transaction ID

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0 #=A0=A0 %x =3D transaction ID (0 if none)

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0 #=A0=A0 %q =3D stop here in non-session

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0 #=A0=A0=A0=A0=A0=A0=A0 processes

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 #=A0=A0 %% =3D '%'

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0 # e.g. '<%u%%%d> '

#log_lock_waits =3D off=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # log lock waits >=3D d= eadlock_timeout

#log_statem= ent =3D 'none'=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0 # none, ddl, mod, all

#log_replication_commands =3D off

#log_temp_files =3D -1=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # log temporary files equal or larg= er

=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # than the specified size in = kilobytes;

=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # -1 disables, 0 log= s all temp files

log_timezo= ne =3D 'Europe/Brussels'

 

 

# - Process Title -

<= p class=3DMsoNormal> 

= #cluster_name =3D ''=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0 # added to process titles if nonempty

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0 # (change requires restart)

#update_process_title =3D off

 

 

#----------------= --------------------------------------------------------------

# RUNTIME STATISTICS<= /p>

#--------------------------------------------= ----------------------------------

 

# - Query/In= dex Statistics Collector -

=  

#track_activities = =3D on

#track_counts =3D = on

#track_io_timing =3D off=

#track_functions =3D none= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # none, = pl, all

#track_activity_qu= ery_size =3D 1024=A0=A0=A0=A0=A0=A0=A0 # (change requires restart)

#stats_temp_directory =3D 'pg_stat_= tmp'

 

 

# - Statistics Monitoring -

 

#log= _parser_stats =3D off

#log= _planner_stats =3D off

#log= _executor_stats =3D off

#lo= g_statement_stats =3D off

<= o:p> 

 

#----------------------------------------= --------------------------------------

# AUTOVACUUM PARAMETERS

#-----------------------------------------------------------------= -------------

 

#autovacuum =3D on=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # Enable autovacuum subproces= s?=A0 'on'

=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # requires track_cou= nts to also be on.

#log_aut= ovacuum_min_duration =3D -1=A0=A0=A0 # -1 disables, 0 logs all actions and<= o:p>

=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # their durations, > 0 logs o= nly

=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # actions running at least= this number

=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # of milliseconds= =2E

#autovacuum_max_workers= =3D 3=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # max number of autovacuum subproce= sses

=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # (change requires restart= )

#autovacuum_naptime =3D 1= min=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # time between autovacuum runs

#autovacuum_vacuum_threshold= =3D 50=A0=A0 # min number of row updates before

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0 # vacuum

#autovacuum_analyze_threshold =3D 50=A0=A0 # min number of row updates bef= ore

=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # analyze

#autovacuum_vacuum_scale_factor =3D 0.2=A0= =A0=A0=A0=A0=A0=A0 # fraction of table size before vacuum=

#autovacuum_analyze_scale_factor =3D 0.1=A0= =A0=A0=A0=A0=A0=A0 # fraction of table size before analyze

#autovacuum_freeze_max_age =3D 200000000=A0= =A0 # maximum XID age before forced vacuum

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0 # (change requires restart)

#autovacuum_multixact_freeze_max_age =3D 400000000=A0=A0=A0= =A0=A0=A0 # maximum multixact age

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0 # before forced vacuum

= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # (ch= ange requires restart)

#aut= ovacuum_vacuum_cost_delay =3D 20ms=A0=A0=A0=A0=A0 # default vacuum cost del= ay for

=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # autovacuum, in millis= econds;

=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # -1 means use vacuum_c= ost_delay

#autovacuum_vacuu= m_cost_limit =3D -1=A0 # default vacuum cost limit for

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0 # autovacuum, -1 means use

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0 # vacuum_cost_limit

 

 

#-----------------------= -------------------------------------------------------

# CLIENT CONNECTION DEFAULTS=

#-------------------------------------------= -----------------------------------

 

# - Stateme= nt Behavior -

 

#search_path =3D '"$user&quo= t;, public'=A0 # schema names

#default_tablespace =3D ''=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # a ta= blespace name, '' uses the default

#temp_tablespaces =3D ''=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # a list of tablespace names, '' uses

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # only default tablespace

#check_function_bodies =3D on

#default_transaction_isolation =3D '= read committed'

#default_tr= ansaction_read_only =3D off

#default_transaction_deferrable =3D off

#session_replication_role =3D 'origin'

<= p class=3DMsoNormal>#statement_timeout =3D 0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # in milliseconds, 0 is disabled=

#lock_timeout =3D 0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # in milliseconds= , 0 is disabled

#idle_in_tr= ansaction_session_timeout =3D 0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0 # in milliseconds, 0 is disabled

#vacuum_freeze_min_age =3D 50000000

#vacuum_freeze_table_age =3D 150000000

#vacuum_multixact_freeze_min_age =3D 5000= 000

#vacuum_multixact_freez= e_table_age =3D 150000000

#= bytea_output =3D 'hex'=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0 # hex, escape

#xmlbinary =3D 'base64'

#xmloption =3D 'content'

#gin_fuzzy_search_limit =3D 0

#gin_pending_list_limit =3D 4MB

 

# - = Locale and Formatting -

 

datestyle =3D 'iso, dmy= '

#intervalstyle =3D 'postg= res'

timezone =3D 'Europe/B= russels'

#timezone_abbrevia= tions =3D 'Default'=A0=A0=A0=A0 # Select the set of available time zone

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # abbreviations.=A0 Currently, ther= e are

=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 #=A0=A0 Default=

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 #=A0=A0 Australia (historical usage)=

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 #=A0=A0 India

=

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0 # You can create your own file in

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0 # share/timezonesets/.

#extra_float_digits =3D 0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # min -15, max 3

#client_encoding =3D sql_ascii=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # actually, defaults to database

=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # encoding

=

 

# These settings are initialized by initdb, but they can be changed.=

lc_messages =3D 'French_Fr= ance.1252'=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0 # locale for system error message

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0 # strings

l= c_monetary =3D 'French_France.1252'=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # locale for monetary formatting<= /o:p>

lc_numeric =3D 'French_France.12= 52'=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0 # locale for number formatting

lc_time =3D 'French_France.1252'=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # loc= ale for time formatting

 

# default configuration= for text search

default_te= xt_search_config =3D 'pg_catalog.french'

 

# - = Other Defaults -

 = ;

#dynamic_library_path =3D '$li= bdir'

#local_preload_librar= ies =3D ''

#session_preload= _libraries =3D ''

&nbs= p;

 

<= p class=3DMsoNormal>#------------------------------------------------= ------------------------------

# LOCK MANAGEMENT

#---= ---------------------------------------------------------------------------=

 

#deadlock_timeout =3D 1s

=

#max_locks_per_transaction =3D 64=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # min 10

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0 # (change requires restart)

#max_pred_locks_per_transaction =3D 64 # min 10

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # (change requires restart)

 

=  

#-------------------------------------= -----------------------------------------

# VERSION/PLATFORM COMPATIBILITY

#----= --------------------------------------------------------------------------<= o:p>

 

# - Previous PostgreSQL Versions -

 

#array_nulls =3D on

#backslash_quote =3D safe_encoding=A0=A0=A0= =A0=A0=A0=A0 # on, off, or safe_encoding

#default_with_oids =3D off

#escape_string_warning =3D on

#lo_compat_privileges =3D off

#operator_precedence_warning =3D off

#quote_all_identifiers =3D off

#sql_inheritance =3D on

#standard_conforming_strings =3D on

#synchronize_seqscans =3D on=

 

# - Other Platforms and Clients -

 

#transform_nul= l_equals =3D off

 

 

#-------------= -----------------------------------------------------------------

# ERROR HANDLING

#-----------------------------------------------------------------------= -------

 

#exit_on_error =3D off=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # terminate session = on any error?

#restart_afte= r_crash =3D on=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # reinitialize after backen= d crash?

 <= /span>

 

#-------------------------------------------------------= -----------------------

# C= ONFIG FILE INCLUDES

#------= ------------------------------------------------------------------------

 

<= p class=3DMsoNormal># These options allow settings to be loaded from = files other than the

# de= fault postgresql.conf.

 

#include_dir =3D 'conf.d= '=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0 # include files ending in '.conf' from

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0 # directory 'conf.d'

#include_if_exists =3D 'exists.conf' # include file only if it exist= s

#include =3D 'special.con= f'=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 # include file<= /p>

 

 

#---------= ---------------------------------------------------------------------<= /o:p>

# CUSTOMIZED OPTIONS<= /span>

#-------------------------------------= -----------------------------------------

 

# Ad= d settings for extensions here

 

 

 




3D"Avast

L'absence de virus dans ce courrier =E9lectronique a =E9t=E9 v=E9rifi= =E9e par le logiciel antivirus Avast.
www.avast.com


=
------=_NextPart_000_02F3_01D486FD.5ABF95A0--