Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kRb1g-0007CL-M2 for pgsql-bugs@arkaria.postgresql.org; Sun, 11 Oct 2020 13:04:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kRb1f-0005Vg-Lh for pgsql-bugs@arkaria.postgresql.org; Sun, 11 Oct 2020 13:04:35 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kRVFr-0000iX-GH for pgsql-bugs@lists.postgresql.org; Sun, 11 Oct 2020 06:54:52 +0000 Received: from [64.147.123.24] (helo=wout1-smtp.messagingengine.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kRVFm-0001XY-Pz for pgsql-bugs@lists.postgresql.org; Sun, 11 Oct 2020 06:54:50 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.42]) by mailout.west.internal (Postfix) with ESMTP id E3B6199C; Sun, 11 Oct 2020 02:54:34 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute2.internal (MEProxy); Sun, 11 Oct 2020 02:54:35 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=mcUvLH 1EDbNp9CmO4LBYdOhxgW6v+zmoXmku1YzrDqo=; b=fN2xmrntVCHXA4Yjr3p1Yt yMa4xP822RkHyuU96Quh3L8RxWF5zJBAjmbZ4gct4jMaiLI73MT9DEaDYnBfKORh lT0pU2Gkobd3IagWK68+7VvUP0QV9GC0CBc6h0IPev6KDivw3mkjvLqEMzSu04bz uXmQ4W+kVGynqwj9NjiqOXbUaxrbDIsiy3rGhAywaN2akdkg7YMQLyf1NwBRBLF7 hkh/ukCIaiw85W10d8SiYF2CmtRyaKXjTFDOPvQy/SKyI64wiOyeF20YQoOsD3c3 2JxgQf1NwQqB7tLLsPWqvYvIztoLVpXmhICQkpDEmdAsIg9kwCnxFXVAILz/GPnA == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedujedrheeggddutdduucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepfffhvffkjghfufggtgesrgdtreertddtjeenucfhrhhomheptfgrphhhrggv lhcuofgvghiirghrihcuoehrrghphhgrvghlsehmvghgiigrrhhirdgtohhmqeenucggtf frrghtthgvrhhnpeeuuddvkeevtdfffefghedujeejfedttdetkeefvddujeejgeekteeu fedvgfefhfenucffohhmrghinhepghhithhhuhgsrdgtohhmpdifrghsrggsihhshihsrd gtohhmpdhsthgrtghkohhvvghrfhhlohifrdgtohhmnecukfhppedutdeirdduheegrddu vdehrdekgeenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhroh hmpehrrghphhgrvghlsehmvghgiigrrhhirdgtohhm X-ME-Proxy: Received: from [192.168.100.149] (kd106154125084.au-net.ne.jp [106.154.125.84]) by mail.messagingengine.com (Postfix) with ESMTPA id AC87D3064674; Sun, 11 Oct 2020 02:54:31 -0400 (EDT) Date: Sun, 11 Oct 2020 15:54:29 +0900 From: Raphael Megzari To: Pavel Stehule Cc: PostgreSQL mailing lists , Thomas Munro Message-ID: In-Reply-To: References: <16665-aaf4e1def393c340@postgresql.org> <5d0420e9-2935-439b-a4a2-543b59c2d8c1@Canary> <536d9e75-1652-43a7-b855-3768511b2b88@Canary> <3e1a2c52-6b71-4f30-adca-08f09a6b3b49@Canary> <116721f8-32b1-4b1b-9023-01e2510bdf55@Canary> Subject: Re: BUG #16665: Segmentation fault MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="5f82ac25_507ed7ab_909c" X-Host-Lookup-Failed: Reverse DNS lookup failed for 64.147.123.24 (deferred) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --5f82ac25_507ed7ab_909c Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline I'm not sure how to install debug symbols for Postgres, if you point me t= o the right resource, I can read it. Here is my full configuration file. I haven't changed so many values =23----------------------------------------------------------------------= -------- =23 =46ILE LOCATIONS =23----------------------------------------------------------------------= -------- =23 The default values of these variables are driven from the -D command-= line =23 option or PGDATA environment variable, represented here as ConfigDir.= =23data=5Fdirectory =3D 'ConfigDir' =23 use data in another directory =23 (change requires restart) =23hba=5Ffile =3D 'ConfigDir/pg=5Fhba.conf' =23 host-based authentication= file =23 (change requires restart) =23ident=5Ffile =3D 'ConfigDir/pg=5Fident.conf' =23 ident configuration f= ile =23 (change requires restart) =23 If external=5Fpid=5Ffile is not explicitly set, no extra PID file is = written. =23external=5Fpid=5Ffile =3D '' =23 write an extra PID file =23 (change requires restart) =23----------------------------------------------------------------------= -------- =23 CONNECTIONS AND AUTHENTICATION =23----------------------------------------------------------------------= -------- =23 - Connection Settings - listen=5Faddresses =3D '*' =23 comma-separated list of addresses; =23 defaults to 'localhost'; use '*' for all =23 (change requires restart) =23port =3D 5432 =23 (change requires restart) max=5Fconnections =3D 300 =23 (change requires restart) =23superuser=5Freserved=5Fconnections =3D 3 =23 (change requires restart)= =23unix=5Fsocket=5Fdirectories =3D '/var/run/postgresql' =23 comma-separa= ted list of directories =23 (change requires restart) =23unix=5Fsocket=5Fgroup =3D '' =23 (change requires restart) =23unix=5Fsocket=5Fpermissions =3D 0777 =23 begin with 0 to use octal not= ation =23 (change requires restart) =23bonjour =3D off =23 advertise server via Bonjour =23 (change requires restart) =23bonjour=5Fname =3D '' =23 defaults to the computer name =23 (change requires restart) =23 - TCP settings - =23 see =22man tcp=22 for details =23tcp=5Fkeepalives=5Fidle =3D 0 =23 TCP=5FKEEPIDLE, in seconds; =23 0 selects the system default =23tcp=5Fkeepalives=5Finterval =3D 0 =23 TCP=5FKEEPINTVL, in seconds; =23 0 selects the system default =23tcp=5Fkeepalives=5Fcount =3D 0 =23 TCP=5FKEEPCNT; =23 0 selects the system default =23tcp=5Fuser=5Ftimeout =3D 0 =23 TCP=5FUSER=5FTIMEOUT, in milliseconds; =23 0 selects the system default =23 - Authentication - =23authentication=5Ftimeout =3D 1min =23 1s-600s =23password=5Fencryption =3D md5 =23 md5 or scram-sha-256 =23db=5Fuser=5Fnamespace =3D off =23 GSSAPI using Kerberos =23krb=5Fserver=5Fkeyfile =3D '' =23krb=5Fcaseins=5Fusers =3D off =23 - SSL - =23ssl =3D off =23ssl=5Fca=5Ffile =3D '' =23ssl=5Fcert=5Ffile =3D 'server.crt' =23ssl=5Fcrl=5Ffile =3D '' =23ssl=5Fkey=5Ffile =3D 'server.key' =23ssl=5Fciphers =3D 'HIGH:MEDIUM:+3DES:=21aNULL' =23 allowed SSL ciphers= =23ssl=5Fprefer=5Fserver=5Fciphers =3D on =23ssl=5Fecdh=5Fcurve =3D 'prime256v1' =23ssl=5Fmin=5Fprotocol=5Fversion =3D 'TLSv1.2' =23ssl=5Fmax=5Fprotocol=5Fversion =3D '' =23ssl=5Fdh=5Fparams=5Ffile =3D '' =23ssl=5Fpassphrase=5Fcommand =3D '' =23ssl=5Fpassphrase=5Fcommand=5Fsupports=5Freload =3D off =23----------------------------------------------------------------------= -------- =23 RESOURCE USAGE (except WAL) =23----------------------------------------------------------------------= -------- =23 - Memory - shared=5Fbuffers =3D 8GB =23 min 128kB =23 (change requires restart) =23huge=5Fpages =3D try =23 on, off, or try =23 (change requires restart) =23temp=5Fbuffers =3D 8MB =23 min 800kB =23max=5Fprepared=5Ftransactions =3D 0 =23 zero disables the feature =23 (change requires restart) =23 Caution: it is not advisable to set max=5Fprepared=5Ftransactions non= zero unless =23 you actively intend to use prepared transactions. work=5Fmem =3D 64MB =23 min 64kB =23hash=5Fmem=5Fmultiplier =3D 1.0 =23 1-1000.0 multiplier on hash table = work=5Fmem maintenance=5Fwork=5Fmem =3D 2GB =23 min 1MB =23autovacuum=5Fwork=5Fmem =3D -1 =23 min 1MB, or -1 to use maintenance=5F= work=5Fmem =23logical=5Fdecoding=5Fwork=5Fmem =3D 64MB =23 min 64kB =23max=5Fstack=5Fdepth =3D 2MB =23 min 100kB =23shared=5Fmemory=5Ftype =3D mmap =23 the default is the first option =23 supported by the operating system: =23 mmap =23 sysv =23 windows =23 (change requires restart) dynamic=5Fshared=5Fmemory=5Ftype =3D posix =23 the default is the first o= ption =23 supported by the operating system: =23 posix =23 sysv =23 windows =23 mmap =23 (change requires restart) =23 - Disk - =23temp=5Ffile=5Flimit =3D -1 =23 limits per-process temp file space =23 in kilobytes, or -1 for no limit =23 - Kernel Resources - =23max=5Ffiles=5Fper=5Fprocess =3D 1000 =23 min 64 =23 (change requires restart) =23 - Cost-Based Vacuum Delay - =23vacuum=5Fcost=5Fdelay =3D 0 =23 0-100 milliseconds (0 disables) =23vacuum=5Fcost=5Fpage=5Fhit =3D 1 =23 0-10000 credits =23vacuum=5Fcost=5Fpage=5Fmiss =3D 10 =23 0-10000 credits =23vacuum=5Fcost=5Fpage=5Fdirty =3D 20 =23 0-10000 credits =23vacuum=5Fcost=5Flimit =3D 200 =23 1-10000 credits =23 - Background Writer - =23bgwriter=5Fdelay =3D 200ms =23 10-10000ms between rounds =23bgwriter=5Flru=5Fmaxpages =3D 100 =23 max buffers written/round, 0 dis= ables =23bgwriter=5Flru=5Fmultiplier =3D 2.0 =23 0-10.0 multiplier on buffers s= canned/round =23bgwriter=5Fflush=5Fafter =3D 512kB =23 measured in pages, 0 disables =23 - Asynchronous Behavior - effective=5Fio=5Fconcurrency =3D 200 =23 1-1000; 0 disables prefetching =23maintenance=5Fio=5Fconcurrency =3D 10 =23 1-1000; 0 disables prefetchi= ng max=5Fworker=5Fprocesses =3D 16 =23 (change requires restart) max=5Fparallel=5Fmaintenance=5Fworkers =3D 4 =23 taken from max=5Fparalle= l=5Fworkers max=5Fparallel=5Fworkers=5Fper=5Fgather =3D 4 =23 taken from max=5Fparall= el=5Fworkers =23parallel=5Fleader=5Fparticipation =3D on max=5Fparallel=5Fworkers =3D 16 =23 maximum number of max=5Fworker=5Fproc= esses that =23 can be used in parallel operations =23old=5Fsnapshot=5Fthreshold =3D -1 =23 1min-60d; -1 disables; 0 is imme= diate =23 (change requires restart) =23backend=5Fflush=5Fafter =3D 0 =23 measured in pages, 0 disables =23----------------------------------------------------------------------= -------- =23 WRITE-AHEAD LOG =23----------------------------------------------------------------------= -------- =23 - Settings - =23wal=5Flevel =3D replica =23 minimal, replica, or logical =23 (change requires restart) =23fsync =3D on =23 flush data to disk for crash safety =23 (turning this off can cause =23 unrecoverable data corruption) =23synchronous=5Fcommit =3D on =23 synchronization level; =23 off, local, remote=5Fwrite, remote=5Fapply, or on =23wal=5Fsync=5Fmethod =3D fsync =23 the default is the first option =23 supported by the operating system: =23 open=5Fdatasync =23 fdatasync (default on Linux) =23 fsync =23 fsync=5Fwritethrough =23 open=5Fsync =23full=5Fpage=5Fwrites =3D on =23 recover from partial page writes =23wal=5Fcompression =3D off =23 enable compression of full-page writes =23wal=5Flog=5Fhints =3D off =23 also do full page writes of non-critical= updates =23 (change requires restart) =23wal=5Finit=5Fzero =3D on =23 zero-fill new WAL files =23wal=5Frecycle =3D on =23 recycle WAL files wal=5Fbuffers =3D 16MB =23 min 32kB, -1 sets based on shared=5Fbuffers =23 (change requires restart) =23wal=5Fwriter=5Fdelay =3D 200ms =23 1-10000 milliseconds =23wal=5Fwriter=5Fflush=5Fafter =3D 1MB =23 measured in pages, 0 disables= =23wal=5Fskip=5Fthreshold =3D 2MB =23commit=5Fdelay =3D 0 =23 range 0-100000, in microseconds =23commit=5Fsiblings =3D 5 =23 range 1-1000 =23 - Checkpoints - =23checkpoint=5Ftimeout =3D 5min =23 range 30s-1d max=5Fwal=5Fsize =3D 8GB min=5Fwal=5Fsize =3D 2GB checkpoint=5Fcompletion=5Ftarget =3D 0.9 =23 checkpoint target duration, = 0.0 - 1.0 =23checkpoint=5Fflush=5Fafter =3D 256kB =23 measured in pages, 0 disables= =23checkpoint=5Fwarning =3D 30s =23 0 disables =23 - Archiving - =23archive=5Fmode =3D off =23 enables archiving; off, on, or always =23 (change requires restart) =23archive=5Fcommand =3D '' =23 command to use to archive a logfile segme= nt =23 placeholders: %p =3D path of file to archive =23 %f =3D file name only =23 e.g. 'test =21 -f /mnt/server/archivedir/%f && cp %p /mnt/server/arch= ivedir/%f' =23archive=5Ftimeout =3D 0 =23 force a logfile segment switch after this =23 number of seconds; 0 disables =23 - Archive Recovery - =23 These are only used in recovery mode. =23restore=5Fcommand =3D '' =23 command to use to restore an archived log= file segment =23 placeholders: %p =3D path of file to restore =23 %f =3D file name only =23 e.g. 'cp /mnt/server/archivedir/%f %p' =23 (change requires restart) =23archive=5Fcleanup=5Fcommand =3D '' =23 command to execute at every res= tartpoint =23recovery=5Fend=5Fcommand =3D '' =23 command to execute at completion o= f recovery =23 - Recovery Target - =23 Set these only when performing a targeted recovery. =23recovery=5Ftarget =3D '' =23 'immediate' to end recovery as soon as a =23 consistent state is reached =23 (change requires restart) =23recovery=5Ftarget=5Fname =3D '' =23 the named restore point to which r= ecovery will proceed =23 (change requires restart) =23recovery=5Ftarget=5Ftime =3D '' =23 the time stamp up to which recover= y will proceed =23 (change requires restart) =23recovery=5Ftarget=5Fxid =3D '' =23 the transaction ID up to which reco= very will proceed =23 (change requires restart) =23recovery=5Ftarget=5Flsn =3D '' =23 the WAL LSN up to which recovery wi= ll proceed =23 (change requires restart) =23recovery=5Ftarget=5Finclusive =3D on =23 Specifies whether to stop: =23 just after the specified recovery target (on) =23 just before the recovery target (off) =23 (change requires restart) =23recovery=5Ftarget=5Ftimeline =3D 'latest' =23 'current', 'latest', or = timeline ID =23 (change requires restart) =23recovery=5Ftarget=5Faction =3D 'pause' =23 'pause', 'promote', 'shutdo= wn' =23 (change requires restart) =23----------------------------------------------------------------------= -------- =23 REPLICATION =23----------------------------------------------------------------------= -------- =23 - Sending Servers - =23 Set these on the master and on any standby that will send replication= data. =23max=5Fwal=5Fsenders =3D 10 =23 max number of walsender processes =23 (change requires restart) =23wal=5Fkeep=5Fsize =3D 0 =23 in megabytes; 0 disables =23max=5Fslot=5Fwal=5Fkeep=5Fsize =3D -1 =23 in megabytes; -1 disables =23wal=5Fsender=5Ftimeout =3D 60s =23 in milliseconds; 0 disables =23max=5Freplication=5Fslots =3D 10 =23 max number of replication slots =23 (change requires restart) =23track=5Fcommit=5Ftimestamp =3D off =23 collect timestamp of transactio= n commit =23 (change requires restart) =23 - Master Server - =23 These settings are ignored on a standby server. =23synchronous=5Fstandby=5Fnames =3D '' =23 standby servers that provide = sync rep =23 method to choose sync standbys, number of sync standbys, =23 and comma-separated list of application=5Fname =23 from standby(s); '*' =3D all =23vacuum=5Fdefer=5Fcleanup=5Fage =3D 0 =23 number of xacts by which clea= nup is delayed =23 - Standby Servers - =23 These settings are ignored on a master server. =23primary=5Fconninfo =3D '' =23 connection string to sending server =23primary=5Fslot=5Fname =3D '' =23 replication slot on sending server =23promote=5Ftrigger=5Ffile =3D '' =23 file name whose presence ends reco= very =23hot=5Fstandby =3D on =23 =22off=22 disallows queries during recovery =23 (change requires restart) =23max=5Fstandby=5Farchive=5Fdelay =3D 30s =23 max delay before canceling= queries =23 when reading WAL from archive; =23 -1 allows indefinite delay =23 (change requires restart) =23max=5Fsync=5Fworkers=5Fper=5Fsubscription =3D 2 =23 taken from max=5Fl= ogical=5Freplication=5Fworkers =23----------------------------------------------------------------------= -------- =23 QUERY TUNING =23----------------------------------------------------------------------= -------- =23 - Planner Method Configuration - =23enable=5Fbitmapscan =3D on =23enable=5Fhashagg =3D on =23enable=5Fhashjoin =3D on =23enable=5Findexscan =3D on =23enable=5Findexonlyscan =3D on =23enable=5Fmaterial =3D on =23enable=5Fmergejoin =3D on =23enable=5Fnestloop =3D on =23enable=5Fparallel=5Fappend =3D on =23enable=5Fseqscan =3D on =23enable=5Fsort =3D on =23enable=5Fincremental=5Fsort =3D on =23enable=5Ftidscan =3D on =23enable=5Fpartitionwise=5Fjoin =3D off =23enable=5Fpartitionwise=5Faggregate =3D off =23enable=5Fparallel=5Fhash =3D on =23enable=5Fpartition=5Fpruning =3D on =23 - Planner Cost Constants - =23seq=5Fpage=5Fcost =3D 1.0 =23 measured on an arbitrary scale random=5Fpage=5Fcost =3D 1.1 =23 same scale as above =23cpu=5Ftuple=5Fcost =3D 0.01 =23 same scale as above =23cpu=5Findex=5Ftuple=5Fcost =3D 0.005 =23 same scale as above =23cpu=5Foperator=5Fcost =3D 0.0025 =23 same scale as above =23parallel=5Ftuple=5Fcost =3D 0.1 =23 same scale as above =23parallel=5Fsetup=5Fcost =3D 1000.0 =23 same scale as above =23jit=5Fabove=5Fcost =3D 100000 =23 perform JIT compilation if available= =23 and query more expensive than this; =23 -1 disables =23jit=5Finline=5Fabove=5Fcost =3D 500000 =23 inline small functions if q= uery is =23 more expensive than this; -1 disables =23jit=5Foptimize=5Fabove=5Fcost =3D 500000 =23 use expensive JIT optimiz= ations if =23 query is more expensive than this; =23 -1 disables =23min=5Fparallel=5Ftable=5Fscan=5Fsize =3D 8MB =23min=5Fparallel=5Findex=5Fscan=5Fsize =3D 512kB effective=5Fcache=5Fsize =3D 24GB =23 - Genetic Query Optimizer - =23geqo =3D on =23geqo=5Fthreshold =3D 12 =23geqo=5Feffort =3D 5 =23 range 1-10 =23geqo=5Fpool=5Fsize =3D 0 =23 selects default based on effort =23geqo=5Fgenerations =3D 0 =23 selects default based on effort =23geqo=5Fselection=5Fbias =3D 2.0 =23 range 1.5-2.0 =23geqo=5Fseed =3D 0.0 =23 range 0.0-1.0 =23 - Other Planner Options - =23default=5Fstatistics=5Ftarget =3D 100 =23 range 1-10000 =23constraint=5Fexclusion =3D partition =23 on, off, or partition =23cursor=5Ftuple=5Ffraction =3D 0.1 =23 range 0.0-1.0 =23from=5Fcollapse=5Flimit =3D 8 =23join=5Fcollapse=5Flimit =3D 8 =23 1 disables collapsing of explicit =23 JOIN clauses =23force=5Fparallel=5Fmode =3D off =23jit =3D on =23 allow JIT compilation =23plan=5Fcache=5Fmode =3D auto =23 auto, force=5Fgeneric=5Fplan or =23 force=5Fcustom=5Fplan =23----------------------------------------------------------------------= -------- =23 REPORTING AND LOGGING =23----------------------------------------------------------------------= -------- =23 - Where to Log - =23log=5Fdestination =3D 'stderr' =23 Valid values are combinations of =23 stderr, csvlog, syslog, and eventlog, =23 depending on platform. csvlog =23 requires logging=5Fcollector to be on. =23 This is used when logging to stderr: =23logging=5Fcollector =3D off =23 Enable capturing of stderr and csvlog =23 into log files. Required to be on for =23 csvlogs. =23 (change requires restart) =23 These are only used if logging=5Fcollector is on: =23log=5Fdirectory =3D 'log' =23 directory where log files are written, =23 can be absolute or relative to PGDATA =23log=5Ffilename =3D 'postgresql-%Y-%m-%d=5F%H%M%S.log' =23 log file nam= e pattern, =23 can include strftime() escapes =23log=5Ffile=5Fmode =3D 0600 =23 creation mode for log files, =23 begin with 0 to use octal notation =23log=5Ftruncate=5Fon=5Frotation =3D off =23 If on, an existing log file= with the =23 same name as the new log file will be =23 truncated rather than appended to. =23 But such truncation only occurs on =23 time-driven rotation, not on restarts =23 or size-driven rotation. Default is =23 off, meaning append to existing files =23 in all cases. =23log=5Frotation=5Fage =3D 1d =23 Automatic rotation of logfiles will =23 happen after that time. 0 disables. =23log=5Frotation=5Fsize =3D 10MB =23 Automatic rotation of logfiles will= =23 happen after that much log output. =23 0 disables. =23 These are relevant when logging to syslog: =23syslog=5Ffacility =3D 'LOCAL0' =23syslog=5Fident =3D 'postgres' =23syslog=5Fsequence=5Fnumbers =3D on =23syslog=5Fsplit=5Fmessages =3D on =23 This is only relevant when logging to eventlog (win32): =23 (change requires restart) =23event=5Fsource =3D 'PostgreSQL' =23 - When to Log - =23log=5Fmin=5Fmessages =3D warning =23 values in order of decreasing det= ail: =23 debug5 =23 debug4 =23 debug3 =23 debug2 =23 debug1 =23 info =23 notice =23 warning =23 error =23 log =23 fatal =23 panic =23log=5Fmin=5Ferror=5Fstatement =3D error =23 values in order of decreas= ing detail: =23 debug5 =23 debug4 =23 debug3 =23 debug2 =23 debug1 =23 info =23 notice =23 warning =23 error =23 log =23 fatal =23 panic (effectively off) =23log=5Fmin=5Fduration=5Fstatement =3D -1 =23 -1 is disabled, 0 logs all= statements =23 and their durations, > 0 logs only =23 statements running at least this number =23 of milliseconds =23log=5Fmin=5Fduration=5Fsample =3D -1 =23 -1 is disabled, 0 logs a samp= le of statements =23 and their durations, > 0 logs only a sample of =23 statements running at least this number =23 of milliseconds; =23 sample fraction is determined by log=5Fstatement=5Fsample=5Frate =23log=5Fstatement=5Fsample=5Frate =3D 1.0 =23 fraction of logged stateme= nts exceeding =23 log=5Fmin=5Fduration=5Fsample to be logged; =23 1.0 logs all such statements, 0.0 never logs =23log=5Ftransaction=5Fsample=5Frate =3D 0.0 =23 fraction of transactions= whose statements =23 are logged regardless of their duration; 1.0 logs all =23 statements from all transactions, 0.0 never logs =23 - What to Log - =23debug=5Fprint=5Fparse =3D off =23debug=5Fprint=5Frewritten =3D off =23debug=5Fprint=5Fplan =3D off =23debug=5Fpretty=5Fprint =3D on =23log=5Fcheckpoints =3D off =23log=5Fconnections =3D off =23log=5Fdisconnections =3D off =23log=5Fduration =3D off =23log=5Ferror=5Fverbosity =3D default =23 terse, default, or verbose mes= sages =23log=5Fhostname =3D off =23log=5Fline=5Fprefix =3D '%m =5B%p=5D ' =23 special values: =23 %a =3D application name =23 %u =3D user name =23 %d =3D database name =23 %r =3D remote host and port =23 %h =3D remote host =23 %b =3D backend type =23 %p =3D process ID =23 %t =3D timestamp without milliseconds =23 %m =3D timestamp with milliseconds =23 %n =3D timestamp with milliseconds (as a Unix epoch) =23 %i =3D command tag =23 %e =3D SQL state =23 %c =3D session ID =23 %l =3D session line number =23 %s =3D session start timestamp =23 %v =3D virtual transaction ID =23 %x =3D transaction ID (0 if none) =23 %q =3D stop here in non-session =23 processes =23 %% =3D '%' =23 e.g. '<%u%%%d> ' =23log=5Flock=5Fwaits =3D off =23 log lock waits >=3D deadlock=5Ftimeout =23log=5Fparameter=5Fmax=5Flength =3D -1 =23 when logging statements, lim= it logged =23 bind-parameter values to N bytes; =23 -1 means print in full, 0 disables =23log=5Fparameter=5Fmax=5Flength=5Fon=5Ferror =3D 0 =23 when logging an = error, limit logged =23 bind-parameter values to N bytes; =23 -1 means print in full, 0 disables =23log=5Fstatement =3D 'none' =23 none, ddl, mod, all =23log=5Freplication=5Fcommands =3D off =23log=5Ftemp=5Ffiles =3D -1 =23 log temporary files equal or larger =23 than the specified size in kilobytes; =23 -1 disables, 0 logs all temp files log=5Ftimezone =3D 'UTC' =23----------------------------------------------------------------------= -------- =23 PROCESS TITLE =23----------------------------------------------------------------------= -------- =23cluster=5Fname =3D '' =23 added to process titles if nonempty =23 (change requires restart) =23update=5Fprocess=5Ftitle =3D on =23----------------------------------------------------------------------= -------- =23 STATISTICS =23----------------------------------------------------------------------= -------- =23 - Query and Index Statistics Collector - =23track=5Factivities =3D on =23track=5Fcounts =3D on =23track=5Fio=5Ftiming =3D off =23track=5Ffunctions =3D none =23 none, pl, all =23track=5Factivity=5Fquery=5Fsize =3D 1024 =23 (change requires restart)= =23stats=5Ftemp=5Fdirectory =3D 'pg=5Fstat=5Ftmp' =23 - Monitoring - =23log=5Fparser=5Fstats =3D off =23log=5Fplanner=5Fstats =3D off =23log=5Fexecutor=5Fstats =3D off =23log=5Fstatement=5Fstats =3D off =23----------------------------------------------------------------------= -------- =23 AUTOVACUUM =23----------------------------------------------------------------------= -------- =23autovacuum =3D on =23 Enable autovacuum subprocess=3F 'on' =23 requires track=5Fcounts to also be on. =23log=5Fautovacuum=5Fmin=5Fduration =3D -1 =23 -1 disables, 0 logs all a= ctions and =23 their durations, > 0 logs only =23 actions running at least this number =23 of milliseconds. =23autovacuum=5Fmax=5Fworkers =3D 3 =23 max number of autovacuum subproce= sses =23 (change requires restart) =23autovacuum=5Fnaptime =3D 1min =23 time between autovacuum runs =23autovacuum=5Fvacuum=5Fthreshold =3D 50 =23 min number of row updates b= efore =23 vacuum =23autovacuum=5Fvacuum=5Finsert=5Fthreshold =3D 1000 =23 min number of ro= w inserts =23 before vacuum; -1 disables insert =23 vacuums =23autovacuum=5Fanalyze=5Fthreshold =3D 50 =23 min number of row updates = before =23 analyze =23autovacuum=5Fvacuum=5Fscale=5Ffactor =3D 0.2 =23 fraction of table siz= e before vacuum =23autovacuum=5Fvacuum=5Finsert=5Fscale=5Ffactor =3D 0.2 =23 fraction of = inserts over table =23 size before insert vacuum =23autovacuum=5Fanalyze=5Fscale=5Ffactor =3D 0.1 =23 fraction of table si= ze before analyze =23autovacuum=5Ffreeze=5Fmax=5Fage =3D 200000000 =23 maximum XID age befo= re forced vacuum =23 (change requires restart) =23autovacuum=5Fmultixact=5Ffreeze=5Fmax=5Fage =3D 400000000 =23 maximum = multixact age =23 before forced vacuum =23 (change requires restart) =23autovacuum=5Fvacuum=5Fcost=5Fdelay =3D 2ms =23 default vacuum cost del= ay for =23 autovacuum, in milliseconds; =23 -1 means use vacuum=5Fcost=5Fdelay =23autovacuum=5Fvacuum=5Fcost=5Flimit =3D -1 =23 default vacuum cost limi= t for =23 autovacuum, -1 means use =23 vacuum=5Fcost=5Flimit =23----------------------------------------------------------------------= -------- =23 CLIENT CONNECTION DE=46AULTS =23----------------------------------------------------------------------= -------- =23 - Statement Behavior - =23client=5Fmin=5Fmessages =3D notice =23 values in order of decreasing d= etail: =23 debug5 =23 debug4 =23 debug3 =23 debug2 =23 debug1 =23 log =23 notice =23 warning =23 error =23search=5Fpath =3D '=22=24user=22, public' =23 schema names =23row=5Fsecurity =3D on =23default=5Ftablespace =3D '' =23 a tablespace name, '' uses the default= =23temp=5Ftablespaces =3D '' =23 a list of tablespace names, '' uses =23 only default tablespace =23default=5Ftable=5Faccess=5Fmethod =3D 'heap' =23check=5Ffunction=5Fbodies =3D on =23default=5Ftransaction=5Fisolation =3D 'read committed' =23default=5Ftransaction=5Fread=5Fonly =3D off =23default=5Ftransaction=5Fdeferrable =3D off =23session=5Freplication=5Frole =3D 'origin' =23statement=5Ftimeout =3D 0 =23 in milliseconds, 0 is disabled =23lock=5Ftimeout =3D 0 =23 in milliseconds, 0 is disabled =23idle=5Fin=5Ftransaction=5Fsession=5Ftimeout =3D 0 =23 in milliseconds,= 0 is disabled =23vacuum=5Ffreeze=5Fmin=5Fage =3D 50000000 =23vacuum=5Ffreeze=5Ftable=5Fage =3D 150000000 =23vacuum=5Fmultixact=5Ffreeze=5Fmin=5Fage =3D 5000000 =23vacuum=5Fmultixact=5Ffreeze=5Ftable=5Fage =3D 150000000 =23vacuum=5Fcleanup=5Findex=5Fscale=5Ffactor =3D 0.1 =23 fraction of tota= l number of tuples =23 before index cleanup, 0 always performs =23 index cleanup =23bytea=5Foutput =3D 'hex' =23 hex, escape =23xmlbinary =3D 'base64' =23xmloption =3D 'content' =23gin=5Ffuzzy=5Fsearch=5Flimit =3D 0 =23gin=5Fpending=5Flist=5Flimit =3D 4MB =23 - Locale and =46ormatting - datestyle =3D 'iso, mdy' =23intervalstyle =3D 'postgres' timezone =3D 'UTC' =23timezone=5Fabbreviations =3D 'Default' =23 Select the set of available= time zone =23 abbreviations. Currently, there are =23 Default =23 Australia (historical usage) =23 India =23 You can create your own file in =23 share/timezonesets/. =23extra=5Ffloat=5Fdigits =3D 1 =23 min -15, max 3; any value >0 actually= =23 selects precise output mode =23client=5Fencoding =3D sql=5Fascii =23 actually, defaults to database =23 encoding =23 These settings are initialized by initdb, but they can be changed. lc=5Fmessages =3D 'en=5FUS.utf8' =23 locale for system error message =23 strings lc=5Fmonetary =3D 'en=5FUS.utf8' =23 locale for monetary formatting lc=5Fnumeric =3D 'en=5FUS.utf8' =23 locale for number formatting lc=5Ftime =3D 'en=5FUS.utf8' =23 locale for time formatting =23 default configuration for text search default=5Ftext=5Fsearch=5Fconfig =3D 'pg=5Fcatalog.english' =23 - Shared Library Preloading - =23shared=5Fpreload=5Flibraries =3D '' =23 (change requires restart) shared=5Fpreload=5Flibraries =3D 'pg=5Fstat=5Fstatements' pg=5Fstat=5Fstatements.track =3D all =23local=5Fpreload=5Flibraries =3D '' =23session=5Fpreload=5Flibraries =3D '' =23jit=5Fprovider =3D 'llvmjit' =23 JIT library to use =23 - Other Defaults - =23dynamic=5Flibrary=5Fpath =3D '=24libdir' =23----------------------------------------------------------------------= -------- =23 LOCK MANAGEMENT =23----------------------------------------------------------------------= -------- =23deadlock=5Ftimeout =3D 1s =23max=5Flocks=5Fper=5Ftransaction =3D 64 =23 min 10 =23 (change requires restart) =23max=5Fpred=5Flocks=5Fper=5Ftransaction =3D 64 =23 min 10 =23 (change requires restart) =23max=5Fpred=5Flocks=5Fper=5Frelation =3D -2 =23 negative values mean =23 (max=5Fpred=5Flocks=5Fper=5Ftransaction =23 / -max=5Fpred=5Flocks=5Fper=5Frelation) - 1 =23max=5Fpred=5Flocks=5Fper=5Fpage =3D 2 =23 min 0 =23----------------------------------------------------------------------= -------- =23 VERSION AND PLAT=46ORM COMPATIBILITY =23----------------------------------------------------------------------= -------- =23 - Previous PostgreSQL Versions - =23array=5Fnulls =3D on =23backslash=5Fquote =3D safe=5Fencoding =23 on, off, or safe=5Fencoding =23escape=5Fstring=5Fwarning =3D on =23lo=5Fcompat=5Fprivileges =3D off =23operator=5Fprecedence=5Fwarning =3D off =23quote=5Fall=5Fidentifiers =3D off =23standard=5Fconforming=5Fstrings =3D on =23synchronize=5Fseqscans =3D on =23 - Other Platforms and Clients - =23transform=5Fnull=5Fequals =3D off =23----------------------------------------------------------------------= -------- =23 ERROR HANDLING =23----------------------------------------------------------------------= -------- =23exit=5Fon=5Ferror =3D off =23 terminate session on any error=3F =23restart=5Fafter=5Fcrash =3D on =23 reinitialize after backend crash=3F= =23data=5Fsync=5Fretry =3D off =23 retry or panic on failure to fsync =23 data=3F =23 (change requires restart) =23----------------------------------------------------------------------= -------- =23 CON=46IG =46ILE INCLUDES =23----------------------------------------------------------------------= -------- =23 These options allow settings to be loaded from files other than the =23 default postgresql.conf. Note that these are directives, not variable= =23 assignments, so they can usefully be given more than once. =23include=5Fdir =3D '...' =23 include files ending in '.conf' from =23 a directory, e.g., 'conf.d' =23include=5Fif=5Fexists =3D '...' =23 include file only if it exists =23include =3D '...' =23 include file =23----------------------------------------------------------------------= -------- =23 CUSTOMIZED OPTIONS =23----------------------------------------------------------------------= -------- =23 Add settings for extensions here > On Sunday, Oct 11, 2020 at 2:37 PM, Pavel Stehule wrote: > > > ne 11. 10. 2020 v 3:13 odes=C3=ADlatel Raphael Megzari napsal: > > ok here is the backtrace that I got > > > > Let me know if you need anything else > > please, can you install debug symbols for Postgres. In this backtrace i= s not detail information. > > It's strange so Postgres crashes in LWLockAttemptLock > > Maybe there is problem in https://github.com/postgres/postgres/commit/b= b16aba50c9492490a0b57e600a932798f45cd4f > > Do you use serializable level of transaction isolations=3F > > > > > > > =230 0x0000556931d0ba55 in LWLockAttemptLock () > > =231 0x0000556931d0c537 in LWLockAcquire () > > =232 0x0000556931cefe83 in ReadBuffer=5Fcommon () > > =233 0x0000556931cf0626 in ReadBufferExtended () > > =234 0x0000556931a8c9b0 in heapgetpage () > > =235 0x0000556931a8cf09 in heapgettup=5Fpagemode () > > =236 0x0000556931a8de3e in heap=5Fgetnextslot () > > =237 0x0000556931bf27fe in SeqNext () > > =238 0x0000556931bd15b7 in ExecScan () > > =239 0x0000556931bf115f in ExecNestLoop () > > =2310 0x0000556931bf115f in ExecNestLoop () > > =2311 0x0000556931be1147 in ExecGather () > > =2312 0x0000556931bc8a2b in standard=5FExecutorRun () > > =2313 0x00007f10dcb8d345 in pgss=5FExecutorRun () from /usr/local/lib= /postgresql/pg=5Fstat=5Fstatements.so > > =2314 0x0000556931d1e41c in PortalRunSelect () > > =2315 0x0000556931d1f5d6 in PortalRun () > > =2316 0x0000556931d1cb58 in PostgresMain () > > =2317 0x0000556931caa3d7 in ServerLoop () > > =2318 0x0000556931cab333 in PostmasterMain () > > =2319 0x0000556931a4db7c in main () > > > > > > > > > > > > > On Saturday, Oct 10, 2020 at 11:57 PM, Pavel Stehule wrote: > > > > > > > > > so 10. 10. 2020 v 16:51 odes=C3=ADlatel Raphael Megzari napsal: > > > > I'm not really sure how to read that binary file. > > > > > > > > I have uploaded to an s3 bucket and made it public. > > > > Anyone should be able to access that file > > > > https://s3.eu-central-1.wasabisys.com/union-backups/core=5Fdump.g= z > > > > > > > > > > > > > > > > > this is not good idea > > > > > > see https://stackoverflow.com/questions/5115613/core-dump-file-anal= ysis > > > > > > Pavel > > > > > > > > > > > > > > > it's 2GB > > > > > > > > If you have a link to a documentation of how I can read that file= and get the stacktrace, I would be glad to give it a read. > > > > > > > > > > > > > > > > > On Saturday, Oct 10, 2020 at 8:56 PM, Pavel Stehule wrote: > > > > > > > > > > > > > > > so 10. 10. 2020 v 13:27 odes=C3=ADlatel Raphael Megzari napsal: > > > > > > Awesome, thank you=21 > > > > > > It's the right thing. > > > > > > > > > > > > How do I share it=3F > > > > > > > > > > important is the backtrace > > > > > > > > > > paste it to mail > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On Saturday, Oct 10, 2020 at 8:24 PM, Pavel Stehule wrote: > > > > > > > > > > > > > > > > > > > > > so 10. 10. 2020 v 13:19 odes=C3=ADlatel Raphael Megzari napsal: > > > > > > > > Thank you for taking the time to have a look. > > > > > > > > > > > > > > > > I'm not sure how to enable core dump with the docker imag= e. > > > > > > > > > > > > > > > > I've seen some documentation where the db is started with= pg=5Fctl anc a =22c=22 flag. I couldn't find anything on enabling it on = the docker image. > > > > > > > > > > > > > > > > in my data folder, I have a huge core file (8 GB). Would = it be possible that it is the core dump file generated after the segfault= =3F > > > > > > > > > > > > > > you can check a create time > > > > > > > > > > > > > > Pavel > > > > > > > > > > > > > > > > > > > > > > > Raphael > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On Saturday, Oct 10, 2020 at 6:04 PM, Pavel Stehule wrote: > > > > > > > > > Hi > > > > > > > > > > > > > > > > > > > > > > > > > > > > > If I can help in any ways, please let me know. > > > > > > > > > > I don't mind trying things, like I said, the bug happ= ens about every 2 > > > > > > > > > > days. > > > > > > > > > > > > > > > > > > This is a bug, but from your bug report isn't possible = to detect any information. > > > > > > > > > > > > > > > > > > Can you enable core dump generating, and can you send a= core dump=3F > > > > > > > > > > > > > > > > > > Regards > > > > > > > > > > > > > > > > > > Pavel > > > > > > > > > > > > > > > > > > > > Cheers=21 > > > > > > > > > > --5f82ac25_507ed7ab_909c Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline <= meta name=3D=22viewport=22 content=3D=22width=3Ddevice-width, initial-sca= le=3D1.0, user-scalable=3Dno=22>
I'm not sure how to install debug symbols for Postgres, if= you point me to the right resource, I can read it.

<= div>Here is my full configuration file. I haven't changed so many values<= /div>

=23----------------------------------------= --------------------------------------
=23 =46ILE LOCATIONS
=23---------------------------------------------------------------= ---------------

=23 The default values of these = variables are driven from the -D command-line
=23 option or PGD= ATA environment variable, represented here as ConfigDir.

=23data=5Fdirectory =3D 'ConfigDir' =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =23 use data in another directory
=C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 (change requires restart)<= /div>
=23hba=5Ffile =3D 'ConfigDir/pg=5Fhba.conf' =C2=A0 =C2=A0 =23 h= ost-based authentication file
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 (change requires restart)
=23= ident=5Ffile =3D 'ConfigDir/pg=5Fident.conf' =23 ident configuration file=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =23 (change requires restart)

=23 If externa= l=5Fpid=5Ffile is not explicitly set, no extra PID file is written.
=
=23external=5Fpid=5Ffile =3D '' =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =23 write an extra PID file
=C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 (change requires re= start)


=23-----------------------= -------------------------------------------------------
=23 CON= NECTIONS AND AUTHENTICATION
=23--------------------------------= ----------------------------------------------

=23= - Connection Settings -

listen=5Faddresses =3D = '*'
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =23 comma-separated list of addresses;
=C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 defaults to 'localh= ost'; use '*' for all
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =23 (change requires restart)
=23port = =3D 5432 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 (change requires restart)
ma= x=5Fconnections =3D 300 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =23 (change requires restart)
=23superuser=5Frese= rved=5Fconnections =3D 3 =C2=A0 =C2=A0 =23 (change requires restart)
=23unix=5Fsocket=5Fdirectories =3D '/var/run/postgresql' =C2=A0 =C2= =A0 =C2=A0 =C2=A0=23 comma-separated list of directories
=C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 (change r= equires restart)
=23unix=5Fsocket=5Fgroup =3D '' =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 (change requires restart)
=23unix=5Fsocket=5Fpermissions =3D 0777 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =23 begin with 0 to use octal notation
=C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 (change requires restar= t)
=23bonjour =3D off =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 advertise server via= Bonjour
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =23 (change requires restart)
=23bonjour=5Fname =3D = '' =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0=23 defaults to the computer name
=C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 (change requires restart)<= /div>

=23 - TCP settings -
=23 see =22man tc= p=22 for details

=23tcp=5Fkeepalives=5Fidle =3D = 0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 TCP=5FKEEPID= LE, in seconds;
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =23 0 selects the system default
=23tcp=5Fkee= palives=5Finterval =3D 0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 TCP= =5FKEEPINTVL, in seconds;
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 0 selects the system default
=23= tcp=5Fkeepalives=5Fcount =3D 0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =23 TCP=5FKEEPCNT;
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 0 selects the system default
=23= tcp=5Fuser=5Ftimeout =3D 0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =23 TCP=5FUSER=5FTIMEOUT, in milliseconds;
=C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 0 selects= the system default

=23 - Authentication -
=

=23authentication=5Ftimeout =3D 1min =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0=23 1s-600s
=23password=5Fencryption =3D md5 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 md5 or scram-sha-256
=23db=5Fuser=5Fnamespace =3D off

=23 GSSA= PI using Kerberos
=23krb=5Fserver=5Fkeyfile =3D ''
=23= krb=5Fcaseins=5Fusers =3D off

=23 - SSL -
<= div>
=23ssl =3D off
=23ssl=5Fca=5Ffile =3D ''
=23ssl=5Fcert=5Ffile =3D 'server.crt'
=23ssl=5Fcrl=5Ffil= e =3D ''
=23ssl=5Fkey=5Ffile =3D 'server.key'
=23ssl=5F= ciphers =3D 'HIGH:MEDIUM:+3DES:=21aNULL' =23 allowed SSL ciphers
=23ssl=5Fprefer=5Fserver=5Fciphers =3D on
=23ssl=5Fecdh=5Fcur= ve =3D 'prime256v1'
=23ssl=5Fmin=5Fprotocol=5Fversion =3D 'TLSv= 1.2'
=23ssl=5Fmax=5Fprotocol=5Fversion =3D ''
=23ssl=5F= dh=5Fparams=5Ffile =3D ''
=23ssl=5Fpassphrase=5Fcommand =3D ''<= /div>
=23ssl=5Fpassphrase=5Fcommand=5Fsupports=5Freload =3D off
=


=23-----------------------------------= -------------------------------------------
=23 RESOURCE USAGE = (except WAL)
=23-----------------------------------------------= -------------------------------

=23 - Memory -

shared=5Fbuffers =3D 8GB =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 min 128kB
=C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 (change r= equires restart)
=23huge=5Fpages =3D try =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 on, off, or try<= /div>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =23 (change requires restart)
=23temp=5Fbuffers =3D 8MB =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 mi= n 800kB
=23max=5Fprepared=5Ftransactions =3D 0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0=23 zero disables the feature
=C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 (change requires re= start)
=23 Caution: it is not advisable to set max=5Fprepared=5F= transactions nonzero unless
=23 you actively intend to use prep= ared transactions.
work=5Fmem =3D 64MB =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 min 64kB<= /div>
=23hash=5Fmem=5Fmultiplier =3D 1.0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0=23 1-1000.0 multiplier on hash table work=5Fmem
maintenance=5Fwork=5Fmem =3D 2GB =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0=23 min 1MB
=23autovacuum=5Fwork=5Fmem =3D -1 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 min 1MB, or -1 to use m= aintenance=5Fwork=5Fmem
=23logical=5Fdecoding=5Fwork=5Fmem =3D = 64MB =C2=A0 =C2=A0 =C2=A0 =23 min 64kB
=23max=5Fstack=5Fdepth =3D= 2MB =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 mi= n 100kB
=23shared=5Fmemory=5Ftype =3D mmap =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 the default is the first option
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 su= pported by the operating system:
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 mmap
=C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 sysv
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23= =C2=A0 windows
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =23 (change requires restart)
dynamic=5Fshare= d=5Fmemory=5Ftype =3D posix =C2=A0 =C2=A0 =C2=A0=23 the default is the fi= rst option
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =23 supported by the operating system:
=C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 posix=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =23 =C2=A0 sysv
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 windows
=C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 mmap
=C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 (change r= equires restart)

=23 - Disk -

=23temp=5Ffile=5Flimit =3D -1 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =23 limits per-process temp file space
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 in= kilobytes, or -1 for no limit

=23 - Kernel Reso= urces -

=23max=5Ffiles=5Fper=5Fprocess =3D 1000 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 min 64
=C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 (change requires re= start)

=23 - Cost-Based Vacuum Delay -

=23vacuum=5Fcost=5Fdelay =3D 0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 0-100 milliseconds (0 disables)
=23vacuum=5Fcost=5Fpage=5Fhit =3D 1 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =23 0-10000 credits
=23vacuum=5Fcost=5Fpage=5F= miss =3D 10 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 0-10000 credits=
=23vacuum=5Fcost=5Fpage=5Fdirty =3D 20 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0=23 0-10000 credits
=23vacuum=5Fcost=5Flimit =3D= 200 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 1-10000 c= redits

=23 - Background Writer -

<= /div>
=23bgwriter=5Fdelay =3D 200ms =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =23 10-10000ms between rounds
=23bgwriter= =5Flru=5Fmaxpages =3D 100 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 ma= x buffers written/round, 0 disables
=23bgwriter=5Flru=5Fmultipl= ier =3D 2.0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 0-10.0 multiplier on bu= ffers scanned/round
=23bgwriter=5Fflush=5Fafter =3D 512kB =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 measured in pages, 0 disables
=
=23 - Asynchronous Behavior -

eff= ective=5Fio=5Fconcurrency =3D 200 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 1= -1000; 0 disables prefetching
=23maintenance=5Fio=5Fconcurrency= =3D 10 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 1-1000; 0 disables prefetching
max=5Fworker=5Fprocesses =3D 16 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =23 (change requires restart)
max=5Fparallel=5Fm= aintenance=5Fworkers =3D 4 =C2=A0 =C2=A0=23 taken from max=5Fparallel=5Fw= orkers
max=5Fparallel=5Fworkers=5Fper=5Fgather =3D 4 =C2=A0 =C2= =A0 =23 taken from max=5Fparallel=5Fworkers
=23parallel=5Fleade= r=5Fparticipation =3D on
max=5Fparallel=5Fworkers =3D 16 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 maximum number of max=5Fwo= rker=5Fprocesses that
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =23 can be used in parallel operations
=23old=5Fsnapshot=5Fthreshold =3D -1 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0=23 1min-60d; -1 disables; 0 is immediate
=C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 (change requires re= start)
=23backend=5Fflush=5Fafter =3D 0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 measured in pages, 0 disables


=23--------------------------------------= ----------------------------------------
=23 WRITE-AHEAD LOG
=23--------------------------------------------------------------= ----------------

=23 - Settings -

=
=23wal=5Flevel =3D replica =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 minimal, replica, or logical
<= div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23= (change requires restart)
=23fsync =3D on =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =23 flush data to disk for crash safety
=C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 (turning this off can c= ause
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =23 unrecoverable data corruption)
=23synchronous=5Fcom= mit =3D on =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 syn= chronization level;
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =23 off, local, remote=5Fwrite, remote=5Fapply, or = on
=23wal=5Fsync=5Fmethod =3D fsync =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 the default is the first option
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 su= pported by the operating system:
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 open=5Fdatasync
= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2= =A0 fdatasync (default on Linux)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 fsync
=C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 fsync= =5Fwritethrough
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =23 =C2=A0 open=5Fsync
=23full=5Fpage=5Fwrite= s =3D on =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23= recover from partial page writes
=23wal=5Fcompression =3D off = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 enable = compression of full-page writes
=23wal=5Flog=5Fhints =3D off =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 als= o do full page writes of non-critical updates
=C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 (change requires re= start)
=23wal=5Finit=5Fzero =3D on =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 zero-fill new WAL files
=23wal=5Frecycle =3D on =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 recycle WAL files
wal=5F= buffers =3D 16MB =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0=23 min 32kB, -1 sets based on shared=5Fbuffers
=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23= (change requires restart)
=23wal=5Fwriter=5Fdelay =3D 200ms =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 1-10000 milliseconds
=23wal=5Fwriter=5Fflush=5Fafter =3D 1MB =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =23 measured in pages, 0 disables
=23wal=5Fskip=5Fthres= hold =3D 2MB

=23commit=5Fdelay =3D 0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 range= 0-100000, in microseconds
=23commit=5Fsiblings =3D 5 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 range 1-10= 00

=23 - Checkpoints -

= =23checkpoint=5Ftimeout =3D 5min =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0=23 range 30s-1d
max=5Fwal=5Fsize =3D 8GB
min=5F= wal=5Fsize =3D 2GB
checkpoint=5Fcompletion=5Ftarget =3D 0.9 =C2= =A0 =C2=A0 =C2=A0=23 checkpoint target duration, 0.0 - 1.0
=23c= heckpoint=5Fflush=5Fafter =3D 256kB =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 measu= red in pages, 0 disables
=23checkpoint=5Fwarning =3D 30s =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 0 disables

<= /div>
=23 - Archiving -

=23archive=5Fmode =3D= off =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 enables archiving; off= , on, or always
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 (chan= ge requires restart)
=23archive=5Fcommand =3D '' =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =23 command to use to archive a logfile segment
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 placeholders: %p =3D path = of file to archive
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 %f =3D file name only
=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 e.g. 'test =21 -f /mnt/ser= ver/archivedir/%f && cp %p /mnt/server/archivedir/%f'
=23= archive=5Ftimeout =3D 0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 forc= e a logfile segment switch after this
=C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =23 number of seconds; 0 disables

=23= - Archive Recovery -

=23 These are only used in= recovery mode.

=23restore=5Fcommand =3D '' =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 command to use to restore an archived lo= gfile segment
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 placeh= olders: %p =3D path of file to restore
=C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =23 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 %f =3D= file name only
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 e.g. = 'cp /mnt/server/archivedir/%f %p'
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =23 (change requires restart)
=23archive=5Fcleanup=5Fco= mmand =3D '' =C2=A0 =23 command to execute at every restartpoint
=23recovery=5Fend=5Fcommand =3D '' =C2=A0 =C2=A0 =C2=A0=23 command to e= xecute at completion of recovery

=23 - Recovery = Target -

=23 Set these only when performing a ta= rgeted recovery.

=23recovery=5Ftarget =3D '' =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 'immediate' to end recovery as soon a= s a
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 consistent state= is reached
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 (change r= equires restart)
=23recovery=5Ftarget=5Fname =3D '' =C2=A0 =C2=A0= =C2=A0=23 the named restore point to which recovery will proceed
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 (change requires restart)
=23recovery=5Ftarget=5Ftime =3D '' =C2=A0 =C2=A0 =C2=A0=23 the t= ime stamp up to which recovery will proceed
=C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =23 (change requires restart)
=23recovery=5Ft= arget=5Fxid =3D '' =C2=A0 =C2=A0 =C2=A0 =23 the transaction ID up to whic= h recovery will proceed
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23= (change requires restart)
=23recovery=5Ftarget=5Flsn =3D '' =C2= =A0 =C2=A0 =C2=A0 =23 the WAL LSN up to which recovery will proceed
=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 (change requires restart)<= /div>
=23recovery=5Ftarget=5Finclusive =3D on =23 Specifies whether t= o stop:
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 just after t= he specified recovery target (on)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =23 just before the recovery target (off)
=C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =23 (change requires restart)
=23recov= ery=5Ftarget=5Ftimeline =3D 'latest' =C2=A0 =C2=A0=23 'current', 'latest'= , or timeline ID
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 (chan= ge requires restart)
=23recovery=5Ftarget=5Faction =3D 'pause' = =C2=A0 =C2=A0 =C2=A0 =23 'pause', 'promote', 'shutdown'
=C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 (change requires restart)
<= br>

=23-----------------------------------------= -------------------------------------
=23 REPLICATION
=23---------------------------------------------------------------------= ---------

=23 - Sending Servers -

=
=23 Set these on the master and on any standby that will send = replication data.

=23max=5Fwal=5Fsenders =3D 10 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 max number of walsender processes<= /div>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 (change requires res= tart)
=23wal=5Fkeep=5Fsize =3D 0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0=23 in megabytes; 0 disables
=23max=5Fslot=5Fw= al=5Fkeep=5Fsize =3D -1 =C2=A0 =C2=A0=23 in megabytes; -1 disables
<= div>=23wal=5Fsender=5Ftimeout =3D 60s =C2=A0 =C2=A0 =C2=A0 =23 in millise= conds; 0 disables

=23max=5Freplication=5Fslots =3D= 10 =C2=A0 =C2=A0 =23 max number of replication slots
=C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 (change requires restart)
=23t= rack=5Fcommit=5Ftimestamp =3D off =C2=A0 =23 collect timestamp of transac= tion commit
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 (change r= equires restart)

=23 - Master Server -

=23 These settings are ignored on a standby server.
=

=23synchronous=5Fstandby=5Fnames =3D '' =23 standby s= ervers that provide sync rep
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =23 method to choose sync standbys, number of sync standbys,
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 and comma-separated list of ap= plication=5Fname
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 from = standby(s); '*' =3D all
=23vacuum=5Fdefer=5Fcleanup=5Fage =3D 0= =C2=A0 =23 number of xacts by which cleanup is delayed

=23 - Standby Servers -

=23 These settin= gs are ignored on a master server.

=23primary=5F= conninfo =3D '' =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0=23 connection string to sending server
=23primary=5Fslot=5F= name =3D '' =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 r= eplication slot on sending server
=23promote=5Ftrigger=5Ffile =3D= '' =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 file name whose p= resence ends recovery
=23hot=5Fstandby =3D on =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =22off=22= disallows queries during recovery
=C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 (change requires restart)
=23max=5Fstandby=5Farchive=5Fdelay =3D 30s =C2=A0 =C2=A0 =C2=A0 =C2= =A0=23 max delay before canceling queries
=C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 when reading WAL from a= rchive;
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =23 -1 allows indefinite delay
=C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 (change requires restar= t)
=23max=5Fsync=5Fworkers=5Fper=5Fsubscription =3D 2 =C2=A0=23= taken from max=5Flogical=5Freplication=5Fworkers


=23-----------------------------------------------------= -------------------------
=23 QUERY TUNING
=23-------= -----------------------------------------------------------------------

=23 - Planner Method Configuration -
=23enable=5Fbitmapscan =3D on
=23enable=5Fhashagg = =3D on
=23enable=5Fhashjoin =3D on
=23enable=5Findexs= can =3D on
=23enable=5Findexonlyscan =3D on
=23enable= =5Fmaterial =3D on
=23enable=5Fmergejoin =3D on
=23en= able=5Fnestloop =3D on
=23enable=5Fparallel=5Fappend =3D on
=23enable=5Fseqscan =3D on
=23enable=5Fsort =3D on
=
=23enable=5Fincremental=5Fsort =3D on
=23enable=5Ftidscan = =3D on
=23enable=5Fpartitionwise=5Fjoin =3D off
=23en= able=5Fpartitionwise=5Faggregate =3D off
=23enable=5Fparallel=5F= hash =3D on
=23enable=5Fpartition=5Fpruning =3D on
=23 - Planner Cost Constants -

=23s= eq=5Fpage=5Fcost =3D 1.0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0=23 measured on an arbitrary scale
random=5F= page=5Fcost =3D 1.1 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0=23 same scale as above
=23cpu=5Ftuple=5Fcost =3D 0.01 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 same scale= as above
=23cpu=5Findex=5Ftuple=5Fcost =3D 0.005 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =23 same scale as above
=23cpu=5Foperator= =5Fcost =3D 0.0025 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 same sca= le as above
=23parallel=5Ftuple=5Fcost =3D 0.1 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 same scale as above
=23paral= lel=5Fsetup=5Fcost =3D 1000.0 =C2=A0 =23 same scale as above
=23jit=5Fabove=5Fcost =3D 100000 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 perform JIT compilation if available
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23= and query more expensive than this;
=C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 -1 disables
=23jit=5F= inline=5Fabove=5Fcost =3D 500000 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 inline s= mall functions if query is
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 more expensive than this; -1 disables
=23jit=5Foptimize=5Fabove=5Fcost =3D 500000 =C2=A0 =C2=A0 =C2=A0 = =23 use expensive JIT optimizations if
=C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 query is more expensive th= an this;
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =23 -1 disables

=23min=5Fparallel=5Ft= able=5Fscan=5Fsize =3D 8MB
=23min=5Fparallel=5Findex=5Fscan=5Fs= ize =3D 512kB
effective=5Fcache=5Fsize =3D 24GB

<= /div>
=23 - Genetic Query Optimizer -

=23geq= o =3D on
=23geqo=5Fthreshold =3D 12
=23geqo=5Feffort = =3D 5 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0=23 range 1-10
=23geqo=5Fpool=5Fsize =3D 0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 selec= ts default based on effort
=23geqo=5Fgenerations =3D 0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 selects default = based on effort
=23geqo=5Fselection=5Fbias =3D 2.0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 range 1.5-2.0
=23geqo=5F= seed =3D 0.0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0=23 range 0.0-1.0

=23 - Oth= er Planner Options -

=23default=5Fstatistics=5Ft= arget =3D 100 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 range 1-10000
=23c= onstraint=5Fexclusion =3D partition =C2=A0 =C2=A0 =C2=A0 =23 on, off, or = partition
=23cursor=5Ftuple=5Ffraction =3D 0.1 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0=23 range 0.0-1.0
=23from=5Fcollapse=5F= limit =3D 8
=23join=5Fcollapse=5Flimit =3D 8 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 1 disables collapsing of explicit<= /div>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =23 JOIN clauses
=23force=5Fparallel=5Fmode =3D off
=23jit =3D on =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 allow JIT compilatio= n
=23plan=5Fcache=5Fmode =3D auto =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =23 auto, force=5Fgeneric=5Fplan or
=C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 force= =5Fcustom=5Fplan


=23-------------= -----------------------------------------------------------------
=23 REPORTING AND LOGGING
=23-------------------------------= -----------------------------------------------

= =23 - Where to Log -

=23log=5Fdestination =3D 's= tderr' =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 Valid values are com= binations of
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =23 stderr, csvlog, syslog, and eventlog,
=C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 depending= on platform. =C2=A0csvlog
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 requires logging=5Fcollector to be on.

=23 This is used when logging to stderr:
=23logging=5Fcollector =3D off =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0=23 Enable capturing of stderr and csvlog
=C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 into log = files. Required to be on for
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 csvlogs.
=C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 (change requires restar= t)

=23 These are only used if logging=5Fcollecto= r is on:
=23log=5Fdirectory =3D 'log' =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 directory where log files are writ= ten,
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =23 can be absolute or relative to PGDATA
=23log=5Ffile= name =3D 'postgresql-%Y-%m-%d=5F%H%M%S.log' =C2=A0 =C2=A0 =C2=A0 =C2=A0=23= log file name pattern,
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =23 can include strftime() escapes
=23= log=5Ffile=5Fmode =3D 0600 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =23 creation mode for log files,
=C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 begin with 0 to use= octal notation
=23log=5Ftruncate=5Fon=5Frotation =3D off =C2=A0= =C2=A0 =C2=A0 =C2=A0 =23 If on, an existing log file with the
= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 sa= me name as the new log file will be
=C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 truncated rather than appended= to.
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =23 But such truncation only occurs on
=C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 time-driven rotatio= n, not on restarts
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =23 or size-driven rotation. =C2=A0Default is
=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23= off, meaning append to existing files
=C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 in all cases.
=23= log=5Frotation=5Fage =3D 1d =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0=23 Automatic rotation of logfiles will
=C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 happen af= ter that time. =C2=A00 disables.
=23log=5Frotation=5Fsize =3D 1= 0MB =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 Automatic rotati= on of logfiles will
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =23 happen after that much log output.
=C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 0 dis= ables.

=23 These are relevant when logging to sy= slog:
=23syslog=5Ffacility =3D 'LOCAL0'
=23syslog=5Fi= dent =3D 'postgres'
=23syslog=5Fsequence=5Fnumbers =3D on
=
=23syslog=5Fsplit=5Fmessages =3D on

=23 Thi= s is only relevant when logging to eventlog (win32):
=23 (chang= e requires restart)
=23event=5Fsource =3D 'PostgreSQL'

=23 - When to Log -

=23log=5Fmi= n=5Fmessages =3D warning =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 va= lues in order of decreasing detail:
=C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 debug5
=C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 de= bug4
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =23 =C2=A0 debug3
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 debug2
=C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 debug1
=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23= =C2=A0 info
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =23 =C2=A0 notice
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 warning
=C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 error=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =23 =C2=A0 log
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 fatal
=C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 panic
=23log=5Fmin=5Ferror=5Fstatement =3D error =C2=A0 =C2=A0 =C2=A0= =C2=A0=23 values in order of decreasing detail:
=C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 debug5
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =23 =C2=A0 debug4
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 debug3
=C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 debug2
=C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0= debug1
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =23 =C2=A0 info
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 notice
=C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 warning
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23= =C2=A0 error
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =23 =C2=A0 log
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 fatal
=C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 panic= (effectively off)

=23log=5Fmin=5Fduration=5Fsta= tement =3D -1 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 -1 is disabled, 0 logs all s= tatements
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =23 and their durations, > 0 logs only
=C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 statements r= unning at least this number
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 of milliseconds

<= div>=23log=5Fmin=5Fduration=5Fsample =3D -1 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =23 -1 is disabled, 0 logs a sample of statements
=C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 and their du= rations, > 0 logs only a sample of
=C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 statements running at least th= is number
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =23 of milliseconds;
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 sample fraction is determined by = log=5Fstatement=5Fsample=5Frate

=23log=5Fstateme= nt=5Fsample=5Frate =3D 1.0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 fraction of log= ged statements exceeding
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 log=5Fmin=5Fduration=5Fsample to be logg= ed;
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =23 1.0 logs all such statements, 0.0 never logs


=23log=5Ftransaction=5Fsample=5Frate =3D 0.0 =C2=A0= =C2=A0 =C2=A0=23 fraction of transactions whose statements
=C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 are l= ogged regardless of their duration; 1.0 logs all
=C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 statements from = all transactions, 0.0 never logs

=23 - What to L= og -

=23debug=5Fprint=5Fparse =3D off
= =23debug=5Fprint=5Frewritten =3D off
=23debug=5Fprint=5Fplan =3D= off
=23debug=5Fpretty=5Fprint =3D on
=23log=5Fcheckp= oints =3D off
=23log=5Fconnections =3D off
=23log=5Fd= isconnections =3D off
=23log=5Fduration =3D off
=23lo= g=5Ferror=5Fverbosity =3D default =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 t= erse, default, or verbose messages
=23log=5Fhostname =3D off
=23log=5Fline=5Fprefix =3D '%m =5B%p=5D ' =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =23 special values:
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 %a =3D application name
<= div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23= =C2=A0 %u =3D user name
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 %d =3D database name
=C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0= %r =3D remote host and port
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 %h =3D remote host
=C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0= %b =3D backend type
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 %p =3D process ID
=C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 %t =3D= timestamp without milliseconds
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 %m =3D timestamp with mill= iseconds
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =23 =C2=A0 %n =3D timestamp with milliseconds (as a Unix epoch= )
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =23 =C2=A0 %i =3D command tag
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 %e =3D SQL state
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2= =A0 %c =3D session ID
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 %l =3D session line number
= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2= =A0 %s =3D session start timestamp
=C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 %v =3D virtual transact= ion ID
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =23 =C2=A0 %x =3D transaction ID (0 if none)
=C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 %q= =3D stop here in non-session
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 =C2=A0 =C2=A0 =C2=A0processes<= /div>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =23 =C2=A0 %% =3D '%'
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 e.g. '<%u%%%d> '
=23log=5F= lock=5Fwaits =3D off =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =23 log lock waits >=3D deadlock=5Ftimeout
=23log= =5Fparameter=5Fmax=5Flength =3D -1 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 = when logging statements, limit logged
=C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 bind-parameter values to N byt= es;
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =23 -1 means print in full, 0 disables
=23log=5Fparamet= er=5Fmax=5Flength=5Fon=5Ferror =3D 0 =C2=A0=23 when logging an error, lim= it logged
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =23 bind-parameter values to N bytes;
=C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 -1 means print i= n full, 0 disables
=23log=5Fstatement =3D 'none' =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 none, ddl, mod, all
=23log=5Freplication=5Fcommands =3D off
=23log=5Ftemp=5Ffile= s =3D -1 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0=23 log temporary files equal or larger
=C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 than the specified size= in kilobytes;
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =23 -1 disables, 0 logs all temp files
log=5F= timezone =3D 'UTC'

=23--------------------------= ----------------------------------------------------
=23 PROCES= S TITLE
=23----------------------------------------------------= --------------------------

=23cluster=5Fname =3D= '' =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0=23 added to process titles if nonempty
=C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 (change requires re= start)
=23update=5Fprocess=5Ftitle =3D on

<= div>
=23---------------------------------------------------= ---------------------------
=23 STATISTICS
=23-------= -----------------------------------------------------------------------

=23 - Query and Index Statistics Collector -

=23track=5Factivities =3D on
=23track=5Fco= unts =3D on
=23track=5Fio=5Ftiming =3D off
=23track=5F= functions =3D none =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =23 none, pl, all
=23track=5Factivity=5Fquery=5Fsize =3D 1024 = =C2=A0 =C2=A0 =C2=A0 =23 (change requires restart)
=23stats=5Ft= emp=5Fdirectory =3D 'pg=5Fstat=5Ftmp'


=
=23 - Monitoring -

=23log=5Fparser=5Fstats = =3D off
=23log=5Fplanner=5Fstats =3D off
=23log=5Fexe= cutor=5Fstats =3D off
=23log=5Fstatement=5Fstats =3D off
<= div>

=23------------------------------------= ------------------------------------------
=23 AUTOVACUUM
=
=23-----------------------------------------------------------------= -------------

=23autovacuum =3D on =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23= Enable autovacuum subprocess=3F =C2=A0'on'
=C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 requires track=5Fcounts= to also be on.
=23log=5Fautovacuum=5Fmin=5Fduration =3D -1 =C2= =A0 =C2=A0 =C2=A0 =23 -1 disables, 0 logs all actions and
=C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 their dur= ations, > 0 logs only
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 actions running at least this number
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =23 of milliseconds.
=23autovacuum=5Fmax=5Fworkers =3D 3 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 max number of autovacuum subproce= sses
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =23 (change requires restart)
=23autovacuum=5Fnaptime =3D= 1min =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 time between au= tovacuum runs
=23autovacuum=5Fvacuum=5Fthreshold =3D 50 =C2=A0 = =C2=A0 =C2=A0 =23 min number of row updates before
=C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 vacuum
=23autovacuum=5Fvacuum=5Finsert=5Fthreshold =3D 1000 =C2=A0 =C2=A0 =C2=A0= =23 min number of row inserts
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 before vacuum; -1 disables insert
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =23 vacuums
=23autovacuum=5Fanalyze=5Fthreshold =3D 50 =C2=A0 = =C2=A0 =C2=A0=23 min number of row updates before
=C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 analyze
=23autovacuum=5Fvacuum=5Fscale=5Ffactor =3D 0.2 =C2=A0 =23 fraction of = table size before vacuum
=23autovacuum=5Fvacuum=5Finsert=5Fscal= e=5Ffactor =3D 0.2 =C2=A0 =C2=A0=23 fraction of inserts over table
<= div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23= size before insert vacuum
=23autovacuum=5Fanalyze=5Fscale=5Ffa= ctor =3D 0.1 =C2=A0=23 fraction of table size before analyze
=23= autovacuum=5Ffreeze=5Fmax=5Fage =3D 200000000 =C2=A0=23 maximum XID age b= efore forced vacuum
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =23 (change requires restart)
=23autovacu= um=5Fmultixact=5Ffreeze=5Fmax=5Fage =3D 400000000 =C2=A0 =C2=A0 =C2=A0 =C2= =A0=23 maximum multixact age
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 before forced vacuum
=C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 (change r= equires restart)
=23autovacuum=5Fvacuum=5Fcost=5Fdelay =3D 2ms = =C2=A0 =C2=A0 =23 default vacuum cost delay for
=C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 autovacuum, in mill= iseconds;
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =23 -1 means use vacuum=5Fcost=5Fdelay
=23autovacuum= =5Fvacuum=5Fcost=5Flimit =3D -1 =C2=A0 =C2=A0 =C2=A0=23 default vacuum co= st limit for
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =23 autovacuum, -1 means use
=C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 vacuum=5Fcost=5Flimit


=23-------------------------------= -----------------------------------------------
=23 CLIENT CONN= ECTION DE=46AULTS
=23------------------------------------------= ------------------------------------

=23 - State= ment Behavior -

=23client=5Fmin=5Fmessages =3D n= otice =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 values in order of decreasin= g detail:
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =23 =C2=A0 debug5
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 debug4
=C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 debug3
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =23 =C2=A0 debug2
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 debug1
=C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 log
=C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 no= tice
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =23 =C2=A0 warning
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 error
=23search=5Fpath = =3D '=22=24user=22, public' =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 schema names
=23row=5Fsecurity =3D on
=23default=5Ftablespace =3D '= ' =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 a tablespace= name, '' uses the default
=23temp=5Ftablespaces =3D '' =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 a list of tabl= espace names, '' uses
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =23 only default tablespace
=23default= =5Ftable=5Faccess=5Fmethod =3D 'heap'
=23check=5Ffunction=5Fbod= ies =3D on
=23default=5Ftransaction=5Fisolation =3D 'read commi= tted'
=23default=5Ftransaction=5Fread=5Fonly =3D off
= =23default=5Ftransaction=5Fdeferrable =3D off
=23session=5Frepl= ication=5Frole =3D 'origin'
=23statement=5Ftimeout =3D 0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 in millisecon= ds, 0 is disabled
=23lock=5Ftimeout =3D 0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 in millisecon= ds, 0 is disabled
=23idle=5Fin=5Ftransaction=5Fsession=5Ftimeou= t =3D 0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 in milliseconds, 0 is disabled
=23vacuum=5Ffreeze=5Fmin=5Fage =3D 50000000
=23vacuum=5F= freeze=5Ftable=5Fage =3D 150000000
=23vacuum=5Fmultixact=5Ffree= ze=5Fmin=5Fage =3D 5000000
=23vacuum=5Fmultixact=5Ffreeze=5Ftab= le=5Fage =3D 150000000
=23vacuum=5Fcleanup=5Findex=5Fscale=5Ffa= ctor =3D 0.1 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 fraction of total number of t= uples
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 before index cleanup, 0 always pe= rforms
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 index cleanup
=23byt= ea=5Foutput =3D 'hex' =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =23 hex, escape
=23xmlbinary =3D 'base64'
= =23xmloption =3D 'content'
=23gin=5Ffuzzy=5Fsearch=5Flimit =3D = 0
=23gin=5Fpending=5Flist=5Flimit =3D 4MB

<= div>=23 - Locale and =46ormatting -

datestyle =3D= 'iso, mdy'
=23intervalstyle =3D 'postgres'
timezone = =3D 'UTC'
=23timezone=5Fabbreviations =3D 'Default' =C2=A0 =C2=A0= =23 Select the set of available time zone
=C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 abbreviations. =C2=A0Cu= rrently, there are
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 Default
=C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 =C2=A0 Australia (historic= al usage)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =23 =C2=A0 India
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 You can create your own file in
=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23= share/timezonesets/.
=23extra=5Ffloat=5Fdigits =3D 1 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 min -15, max 3; any val= ue >0 actually
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =23 selects precise output mode
=23client= =5Fencoding =3D sql=5Fascii =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 = actually, defaults to database
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 encoding

=23= These settings are initialized by initdb, but they can be changed.
=
lc=5Fmessages =3D 'en=5FUS.utf8' =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 locale for system error mess= age
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =23 strings
lc=5Fmonetary =3D 'en=5FUS.utf8' =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 loc= ale for monetary formatting
lc=5Fnumeric =3D 'en=5FUS.utf8' =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =23 locale for number formatting
lc=5Ftime =3D 'en=5FUS.utf8' = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0=23 locale for time formatting

= =23 default configuration for text search
default=5Ftext=5Fsear= ch=5Fconfig =3D 'pg=5Fcatalog.english'

=23 - Sha= red Library Preloading -

=23shared=5Fpreload=5Fl= ibraries =3D '' =C2=A0=23 (change requires restart)
shared=5Fpr= eload=5Flibraries =3D 'pg=5Fstat=5Fstatements'
pg=5Fstat=5Fstat= ements.track =3D all
=23local=5Fpreload=5Flibraries =3D ''
=23session=5Fpreload=5Flibraries =3D ''
=23jit=5Fprovider= =3D 'llvmjit' =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 JIT l= ibrary to use

=23 - Other Defaults -
<= br>
=23dynamic=5Flibrary=5Fpath =3D '=24libdir'

<= /div>

=23---------------------------------------------= ---------------------------------
=23 LOCK MANAGEMENT
=23---------------------------------------------------------------------= ---------

=23deadlock=5Ftimeout =3D 1s
=23max=5Flocks=5Fper=5Ftransaction =3D 64 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23= min 10
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =23 (change requires restart)
=23max=5Fpred=5Flocks=5F= per=5Ftransaction =3D 64 =C2=A0 =C2=A0=23 min 10
=C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 (change requires= restart)
=23max=5Fpred=5Flocks=5Fper=5Frelation =3D -2 =C2=A0 = =C2=A0 =C2=A0 =23 negative values mean
=C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 (max=5Fpred=5Flocks=5Fper=5F= transaction
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =23 =C2=A0/ -max=5Fpred=5Flocks=5Fper=5Frelation) - 1
=23max=5Fpred=5Flocks=5Fper=5Fpage =3D 2 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0=23 min 0


=23------= ------------------------------------------------------------------------<= /div>
=23 VERSION AND PLAT=46ORM COMPATIBILITY
=23---------= ---------------------------------------------------------------------

=23 - Previous PostgreSQL Versions -

=
=23array=5Fnulls =3D on
=23backslash=5Fquote =3D saf= e=5Fencoding =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 on, off, or safe=5Fencoding
=23escape=5Fstring=5Fwarning =3D on
=23lo=5Fcompat=5Fp= rivileges =3D off
=23operator=5Fprecedence=5Fwarning =3D off
=23quote=5Fall=5Fidentifiers =3D off
=23standard=5Fconf= orming=5Fstrings =3D on
=23synchronize=5Fseqscans =3D on
<= div>
=23 - Other Platforms and Clients -

=23transform=5Fnull=5Fequals =3D off


=
=23-----------------------------------------------------------= -------------------
=23 ERROR HANDLING
=23-----------= -------------------------------------------------------------------
=

=23exit=5Fon=5Ferror =3D off =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 terminate session on any= error=3F
=23restart=5Fafter=5Fcrash =3D on =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 reinitialize after backend crash=3F
=23data=5Fsync=5Fretry =3D off =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0=23 retry or panic on failure to fsync
= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 da= ta=3F
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =23 (change requires restart)


=
=23-----------------------------------------------------------------= -------------
=23 CON=46IG =46ILE INCLUDES
=23-------= -----------------------------------------------------------------------

=23 These options allow settings to be loaded fro= m files other than the
=23 default postgresql.conf. =C2=A0Note = that these are directives, not variable
=23 assignments, so the= y can usefully be given more than once.

=23inclu= de=5Fdir =3D '...' =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0=23 include files ending in '.conf' from
=C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 a directory,= e.g., 'conf.d'
=23include=5Fif=5Fexists =3D '...' =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 include file only if it exists
=23include =3D '...' =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 include file


=23------------------------------------------------= ------------------------------
=23 CUSTOMIZED OPTIONS
=23---------------------------------------------------------------------= ---------

=23 Add settings for extensions here



On Sunday, Oct 11, 2020 at 2:37 PM, Pavel Stehule &l= t;pavel.stehule=40gmail.= com> wrote:


ne 11. 10. 2020 v=C2=A03:13 odes=C3=ADlatel Raphae= l Megzari <raphael=40megz= ari.com> napsal:
ok here i= s the backtrace that I got

Let me know if you ne= ed anything else

please= , can you install debug symbols for Postgres. In this backtrace is not de= tail information.

It's strange so Postgres crash= es in LWLockAttemptLock


Do= you use serializable level of transaction isolations=3F




=230 =C2=A00x0000556931d0ba55 in LWLockAttemptLock = ()
=231 =C2=A00x0000556931d0c537 in LWLockAcquire ()
= =232 =C2=A00x0000556931cefe83 in ReadBuffer=5Fcommon ()
=233 =C2= =A00x0000556931cf0626 in ReadBufferExtended ()
=234 =C2=A00x000= 0556931a8c9b0 in heapgetpage ()
=235 =C2=A00x0000556931a8cf09 i= n heapgettup=5Fpagemode ()
=236 =C2=A00x0000556931a8de3e in hea= p=5Fgetnextslot ()
=237 =C2=A00x0000556931bf27fe in SeqNext ()<= /div>
=238 =C2=A00x0000556931bd15b7 in ExecScan ()
=239 =C2= =A00x0000556931bf115f in ExecNestLoop ()
=2310 0x0000556931bf11= 5f in ExecNestLoop ()
=2311 0x0000556931be1147 in ExecGather ()=
=2312 0x0000556931bc8a2b in standard=5FExecutorRun ()
=2313 0x00007f10dcb8d345 in pgss=5FExecutorRun () from /usr/local/lib/p= ostgresql/pg=5Fstat=5Fstatements.so
=2314 0x0000556931d1e41c in= PortalRunSelect ()
=2315 0x0000556931d1f5d6 in PortalRun ()
=2316 0x0000556931d1cb58 in PostgresMain ()
=2317 0x000= 0556931caa3d7 in ServerLoop ()
=2318 0x0000556931cab333 in Post= masterMain ()
=2319 0x0000556931a4db7c in main ()




On Saturday, Oct 10, 2020 at 11:57 PM, Pavel Stehule <pav= el.stehule=40gmail.com> wrote:


so 10. 10. 2020 v=C2=A016:51 = odes=C3=ADlatel Raphael Megzari <raphael=40megzari.com> napsal:
=
I'm not really sure how to read that binary file.

I have uploaded to an s3 bucket and made it public.
Anyone should be able to access that file

this is not good idea

Pavel



it's =C2= =A02GB

If you have a link to a documentation of = how I can read that file and get the stacktrace, I would be glad to give = it a read.



On Saturday, Oct 10, 2020 at 8:56 PM, = Pavel Stehule <pavel.stehule=40gmail.com> wrote:


so 10. 1= 0. 2020 v=C2=A013:27 odes=C3=ADlatel Raphael Megzari <raphael=40megzari.co= m> napsal:
Awesome, thank you=21
It's the right thing.

How do I share it=3F

important is the backtrace

= paste it to mail


=



=
On Saturday, Oct 10, 2020 at 8:24 PM,= Pavel Stehule <pavel.stehule=40gmail.com> wrote:


so 10. 1= 0. 2020 v=C2=A013:19 odes=C3=ADlatel Raphael Megzari <raphael=40megzari.co= m> napsal:
Th= ank you for taking the time to have a look.

I'm = not sure how to enable core dump with the docker image.

I've seen some documentation where the db is started with pg=5Fct= l anc a =22c=22 flag. I couldn't find anything on enabling it on the dock= er image.

in my data folder, I have a huge core = file (8 GB). Would it be possible that it is the core dump file generated= after the segfault=3F

= you can check a create time

Pavel

=

=
Raphael




=
<= div>
On Saturday, Oct 10, 2020 at 6:04 PM, Pavel Stehule <pavel.s= tehule=40gmail.com> wrote:
Hi


If I can help i= n any ways, please let me know.
I don't mind trying things, like I sa= id, the bug happens about every 2
days.

This is a bug, but from your bug report isn't possible to detect a= ny information.

Can you enable core dump g= enerating, and can you send a core dump=3F

Regar= ds

Pavel

Cheers=21

--5f82ac25_507ed7ab_909c--