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 1kSFGD-0005c5-SV for pgsql-bugs@arkaria.postgresql.org; Tue, 13 Oct 2020 08:02:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kSFGC-0006ya-4x for pgsql-bugs@arkaria.postgresql.org; Tue, 13 Oct 2020 08:02:16 +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 1kSB2M-0007x6-En for pgsql-bugs@lists.postgresql.org; Tue, 13 Oct 2020 03:31:43 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kSB2C-0007C7-Lj for pgsql-bugs@lists.postgresql.org; Tue, 13 Oct 2020 03:31:40 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.42]) by mailout.nyi.internal (Postfix) with ESMTP id B7CBF5C015B; Mon, 12 Oct 2020 23:31:30 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute2.internal (MEProxy); Mon, 12 Oct 2020 23:31:30 -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=RwPOvZ WPPRWlJ/3gyiIzNKeFOf4VbIIYp1CQzw5anw8=; b=P35HPT41T7Vvaolc3MEqaG /5kJnfchwo6OEG1hdMtdhs67v7YICsKF3AjOlsR6o17ukmrLfEzrUEtyS5aN0wpV E7HfdrB3PxA5hmTR94/QYhChndX/Vw3rkrPpS/7TVeqvFLIeEPMSnzgWL+AiebIz gqq/+gk+emCTukuupo7JPlO+L7zoaZGfmN9z6LSXilIH84yochZKJR0GknFj4Ydy +K/DZ4g2oTU5kcPd1GIWWhapmgorvxlm4PtvVWTbMhXlpbHzpwkj9GrcddTEtAGz CzvwYUOYicmEkh5KWp3dMLhqvnnoHF36CF0i22iSOlsQPAg42hyB/lC6vJ1NqCMQ == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedujedrheekgdejgecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc fjughrpeffhffvkfgjfhfugggtsegrtderredttdejnecuhfhrohhmpeftrghphhgrvghl ucfovghgiigrrhhiuceorhgrphhhrggvlhesmhgvghiirghrihdrtghomheqnecuggftrf grthhtvghrnhepueduvdekvedtffefgfehudejjeeftddtteekfedvudejjeegkeetueef vdfgfefhnecuffhomhgrihhnpehgihhthhhusgdrtghomhdpfigrshgrsghishihshdrtg homhdpshhtrggtkhhovhgvrhhflhhofidrtghomhenucfkphepudduuddrvdefledrudek kedrudehieenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhroh hmpehrrghphhgrvghlsehmvghgiigrrhhirdgtohhm X-ME-Proxy: Received: from [192.168.100.144] (kd111239188156.au-net.ne.jp [111.239.188.156]) by mail.messagingengine.com (Postfix) with ESMTPA id 83851328005E; Mon, 12 Oct 2020 23:31:27 -0400 (EDT) Date: Tue, 13 Oct 2020 12:31:23 +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="5f851f8c_643c9869_ebc6" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --5f851f8c_643c9869_ebc6 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Thanks for the issue, that is spot on. So it looks like I won't be able to get a debug image for docker. I have one question though. The core dump came from postgres 13.0 built f= or alpine. Would I be able to debug it, if I got postgres 13.0 on my macO= S with the debug symbols and tried to debug on my local machine=3F Those = binaries are different but come from the same version of postgres, would = that work=3F > On Sunday, Oct 11, 2020 at 4:13 PM, Pavel Stehule wrote: > > > ne 11. 10. 2020 v 8:54 odes=C3=ADlatel Raphael Megzari napsal: > > I'm not sure how to install debug symbols for Postgres, if you point = me to the right resource, I can read it. > > it is a separate package - it has no relation to Postgres configuration= . > > maybe this thread is related https://github.com/docker-library/postgres= /issues/666 > > Pavel > > > > > 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 comm= and-line > > =23 option or PGDATA environment variable, represented here as Config= Dir. > > > > =23data=5Fdirectory =3D 'ConfigDir' =23 use data in another directory= > > =23 (change requires restart) > > =23hba=5Ffile =3D 'ConfigDir/pg=5Fhba.conf' =23 host-based authentica= tion file > > =23 (change requires restart) > > =23ident=5Ffile =3D 'ConfigDir/pg=5Fident.conf' =23 ident configurati= on file > > =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 rest= art) > > =23unix=5Fsocket=5Fdirectories =3D '/var/run/postgresql' =23 comma-se= parated 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= notation > > =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 millisecon= ds; > > =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 cip= hers > > =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= nonzero 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 ta= ble work=5Fmem > > maintenance=5Fwork=5Fmem =3D 2GB =23 min 1MB > > =23autovacuum=5Fwork=5Fmem =3D -1 =23 min 1MB, or -1 to use maintenan= ce=5Fwork=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 optio= n > > =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 fir= st option > > =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= disables > > =23bgwriter=5Flru=5Fmultiplier =3D 2.0 =23 0-10.0 multiplier on buffe= rs scanned/round > > =23bgwriter=5Fflush=5Fafter =3D 512kB =23 measured in pages, 0 disabl= es > > > > =23 - Asynchronous Behavior - > > > > effective=5Fio=5Fconcurrency =3D 200 =23 1-1000; 0 disables prefetchi= ng > > =23maintenance=5Fio=5Fconcurrency =3D 10 =23 1-1000; 0 disables prefe= tching > > max=5Fworker=5Fprocesses =3D 16 =23 (change requires restart) > > max=5Fparallel=5Fmaintenance=5Fworkers =3D 4 =23 taken from max=5Fpar= allel=5Fworkers > > max=5Fparallel=5Fworkers=5Fper=5Fgather =3D 4 =23 taken from max=5Fpa= rallel=5Fworkers > > =23parallel=5Fleader=5Fparticipation =3D on > > max=5Fparallel=5Fworkers =3D 16 =23 maximum number of max=5Fworker=5F= processes that > > =23 can be used in parallel operations > > =23old=5Fsnapshot=5Fthreshold =3D -1 =23 1min-60d; -1 disables; 0 is = immediate > > =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 writ= es > > =23wal=5Flog=5Fhints =3D off =23 also do full page writes of non-crit= ical 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=5Fbuffer= s > > =23 (change requires restart) > > =23wal=5Fwriter=5Fdelay =3D 200ms =23 1-10000 milliseconds > > =23wal=5Fwriter=5Fflush=5Fafter =3D 1MB =23 measured in pages, 0 disa= bles > > =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 durati= on, 0.0 - 1.0 > > =23checkpoint=5Fflush=5Fafter =3D 256kB =23 measured in pages, 0 disa= bles > > =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 s= egment > > =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/= archivedir/%f' > > =23archive=5Ftimeout =3D 0 =23 force a logfile segment switch after t= his > > =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= logfile 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= restartpoint > > =23recovery=5Fend=5Fcommand =3D '' =23 command to execute at completi= on of recovery > > > > =23 - Recovery Target - > > > > =23 Set these only when performing a targeted recovery. > > > > =23recovery=5Ftarget =3D '' =23 'immediate' to end recovery as soon a= s a > > =23 consistent state is reached > > =23 (change requires restart) > > =23recovery=5Ftarget=5Fname =3D '' =23 the named restore point to whi= ch recovery will proceed > > =23 (change requires restart) > > =23recovery=5Ftarget=5Ftime =3D '' =23 the time stamp up to which rec= overy will proceed > > =23 (change requires restart) > > =23recovery=5Ftarget=5Fxid =3D '' =23 the transaction ID up to which = recovery will proceed > > =23 (change requires restart) > > =23recovery=5Ftarget=5Flsn =3D '' =23 the WAL LSN up to which recover= y will 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', 'sh= utdown' > > =23 (change requires restart) > > > > > > =23------------------------------------------------------------------= ------------ > > =23 REPLICATION > > =23------------------------------------------------------------------= ------------ > > > > =23 - Sending Servers - > > > > =23 Set these on the master and on any standby that will send replica= tion 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 disable= s > > =23wal=5Fsender=5Ftimeout =3D 60s =23 in milliseconds; 0 disables > > > > =23max=5Freplication=5Fslots =3D 10 =23 max number of replication slo= ts > > =23 (change requires restart) > > =23track=5Fcommit=5Ftimestamp =3D off =23 collect timestamp of transa= ction 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 prov= ide 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 = cleanup 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 serve= r > > =23promote=5Ftrigger=5Ffile =3D '' =23 file name whose presence ends = recovery > > =23hot=5Fstandby =3D on =23 =22off=22 disallows queries during recove= ry > > =23 (change requires restart) > > =23max=5Fstandby=5Farchive=5Fdelay =3D 30s =23 max delay before cance= ling 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= =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=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 avail= able > > =23 and query more expensive than this; > > =23 -1 disables > > =23jit=5Finline=5Fabove=5Fcost =3D 500000 =23 inline small functions = if query is > > =23 more expensive than this; -1 disables > > =23jit=5Foptimize=5Fabove=5Fcost =3D 500000 =23 use expensive JIT opt= imizations 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 explici= t > > =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 o= f > > =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 csv= log > > =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 writte= n, > > =23 can be absolute or relative to PGDATA > > =23log=5Ffilename =3D 'postgresql-%Y-%m-%d=5F%H%M%S.log' =23 log file= name 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 wil= l > > =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= 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 > > > > =23log=5Fmin=5Ferror=5Fstatement =3D error =23 values in order of dec= reasing 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 = sample 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 sta= tements 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 transact= ions 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= messages > > =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=5Ftime= out > > =23log=5Fparameter=5Fmax=5Flength =3D -1 =23 when logging statements,= limit 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 rest= art) > > =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 a= ll actions 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 subp= rocesses > > =23 (change requires restart) > > =23autovacuum=5Fnaptime =3D 1min =23 time between autovacuum runs > > =23autovacuum=5Fvacuum=5Fthreshold =3D 50 =23 min number of row updat= es before > > =23 vacuum > > =23autovacuum=5Fvacuum=5Finsert=5Fthreshold =3D 1000 =23 min number o= f row inserts > > =23 before vacuum; -1 disables insert > > =23 vacuums > > =23autovacuum=5Fanalyze=5Fthreshold =3D 50 =23 min number of row upda= tes before > > =23 analyze > > =23autovacuum=5Fvacuum=5Fscale=5Ffactor =3D 0.2 =23 fraction of table= size 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 tabl= e size before analyze > > =23autovacuum=5Ffreeze=5Fmax=5Fage =3D 200000000 =23 maximum XID age = before forced vacuum > > =23 (change requires restart) > > =23autovacuum=5Fmultixact=5Ffreeze=5Fmax=5Fage =3D 400000000 =23 maxi= mum multixact age > > =23 before forced vacuum > > =23 (change requires restart) > > =23autovacuum=5Fvacuum=5Fcost=5Fdelay =3D 2ms =23 default vacuum cost= delay for > > =23 autovacuum, in milliseconds; > > =23 -1 means use vacuum=5Fcost=5Fdelay > > =23autovacuum=5Fvacuum=5Fcost=5Flimit =3D -1 =23 default vacuum cost = limit 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 decreasi= ng detail: > > =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 def= ault > > =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 milliseco= nds, 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 = total 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 avail= able 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 actu= ally > > =23 selects precise output mode > > =23client=5Fencoding =3D sql=5Fascii =23 actually, defaults to databa= se > > =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 mea= n > > =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=5Fencod= ing > > =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 cras= h=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 t= he > > =23 default postgresql.conf. Note that these are directives, not vari= able > > =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 backtra= ce is not detail information. > > > > > > It's strange so Postgres crashes in LWLockAttemptLock > > > > > > Maybe there is problem in https://github.com/postgres/postgres/comm= it/bb16aba50c9492490a0b57e600a932798f45cd4f > > > > > > 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=5Fdu= mp.gz > > > > > > > > > > > > > > > > > > > > > > > > > > > this is not good idea > > > > > > > > > > see https://stackoverflow.com/questions/5115613/core-dump-file-= analysis > > > > > > > > > > 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 = image. > > > > > > > > > > > > > > > > > > > > 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). Wo= uld it be possible that it is the core dump file generated after the segf= ault=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 = happens about every 2 > > > > > > > > > > > > days. > > > > > > > > > > > > > > > > > > > > > > This is a bug, but from your bug report isn't possi= ble to detect any information. > > > > > > > > > > > > > > > > > > > > > > Can you enable core dump generating, and can you se= nd a core dump=3F > > > > > > > > > > > > > > > > > > > > > > Regards > > > > > > > > > > > > > > > > > > > > > > Pavel > > > > > > > > > > > > > > > > > > > > > > > > Cheers=21 > > > > > > > > > > > > --5f851f8c_643c9869_ebc6 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>
Thanks for the issue, that is spot on.
So it looks l= ike I won't be able to get a debug image for docker.

=
I have one question though. The core dump came from postgres 13.0 bu= ilt for alpine. Would I be able to debug it, if I got postgres 13.0 on my= macOS with the debug symbols and tried to debug on my local machine=3F T= hose binaries are different but come from the same version of postgres, w= ould that work=3F

=


On Sunday, Oct 11, 2020 at 4:13 PM, Pavel= Stehule <pavel.stehu= le=40gmail.com> wrote:


ne 11. 10. 2020 v=C2=A08:54 odes=C3=ADlatel Raphael Megzari <raphael=40megzari.com> na= psal:
I'm not sure how to install de= bug symbols for Postgres, if you point me to the right resource, I can re= ad it.

it is a separate= package - it has no relation to Postgres configuration.


Pavel


Here is my full c= onfiguration 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 PGDATA environment varia= ble, represented here as ConfigDir.

=23data=5Fdi= rectory =3D 'ConfigDir' =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 use data i= n 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)
=23hba=5Ffi= le =3D 'ConfigDir/pg=5Fhba.conf' =C2=A0 =C2=A0 =23 host-based authenticat= ion 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)
=23ident=5Ffile =3D 'C= onfigDir/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 requ= ires restart)

=23 If external=5Fpid=5Ffile is no= t explicitly set, no extra PID file is written.
=23external=5Fp= id=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 restart)
<= br>

=23-----------------------------------------= -------------------------------------
=23 CONNECTIONS AND AUTHE= NTICATION
=23--------------------------------------------------= ----------------------------

=23 - Connection Se= ttings -

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 'localhost'; 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)
max=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=5Freserved=5Fconnections = =3D 3 =C2=A0 =C2=A0 =23 (change requires restart)
=23unix=5Fsoc= ket=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 requires 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=5Fso= cket=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 restart)
=23bonjo= ur =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 (chan= ge 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 t= o 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 tcp=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=5FKEEPIDLE, in seconds;
<= 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= 0 selects the system default
=23tcp=5Fkeepalives=5Finterval =3D= 0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 TCP=5FKEEPINTVL, in secon= ds;
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =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=5Fkeepalives=5F= count =3D 0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 TCP=5FKE= EPCNT;
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =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=5Fuser=5Ftim= eout =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 de= fault

=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=5F= user=5Fnamespace =3D off

=23 GSSAPI using Kerber= os
=23krb=5Fserver=5Fkeyfile =3D ''
=23krb=5Fcaseins=5F= users =3D off

=23 - SSL -

=23ssl =3D off
=23ssl=5Fca=5Ffile =3D ''
=23ssl=5F= cert=5Ffile =3D 'server.crt'
=23ssl=5Fcrl=5Ffile =3D ''
=23ssl=5Fkey=5Ffile =3D 'server.key'
=23ssl=5Fciphers =3D 'H= IGH:MEDIUM:+3DES:=21aNULL' =23 allowed SSL ciphers
=23ssl=5Fpre= fer=5Fserver=5Fciphers =3D on
=23ssl=5Fecdh=5Fcurve =3D 'prime2= 56v1'
=23ssl=5Fmin=5Fprotocol=5Fversion =3D 'TLSv1.2'
=23ssl=5Fmax=5Fprotocol=5Fversion =3D ''
=23ssl=5Fdh=5Fparams=5F= file =3D ''
=23ssl=5Fpassphrase=5Fcommand =3D ''
=23s= sl=5Fpassphrase=5Fcommand=5Fsupports=5Freload =3D off


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

=23 - Memory -

<= /div>
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 requires restar= t)
=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
=C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =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)
=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 min 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 restart)
=23= Caution: it is not advisable to set max=5Fprepared=5Ftransactions nonzer= o unless
=23 you actively intend to use prepared transactions.<= /div>
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
=23hash=5Fm= em=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=5Fwor= k=5Fmem =3D 2GB =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 min 1= MB
=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 maintenance=5Fwork=5Fmem<= /div>
=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 min 100kB
=23shar= ed=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 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 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 (c= hange requires restart)
dynamic=5Fshared=5Fmemory=5Ftype =3D po= six =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 suppo= rted 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 requires restart)

=23 - Disk -

=23temp=5Ffile=5F= limit =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 Resources -

=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 restart)

=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=5F= page=5Fhit =3D 1 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 0-1= 0000 credits
=23vacuum=5Fcost=5Fpage=5Fmiss =3D 10 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 0-10000 credits
=23vacuum=5Fco= st=5Fpage=5Fdirty =3D 20 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 0-1= 0000 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 credits

<= /div>
=23 - Background Writer -

=23bgwriter=5F= delay =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 max buffers written/round, = 0 disables
=23bgwriter=5Flru=5Fmultiplier =3D 2.0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0=23 0-10.0 multiplier on buffers scanned/round
=
=23bgwriter=5Fflush=5Fafter =3D 512kB =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =23 measured in pages, 0 disables

=23 - Asyn= chronous Behavior -

effective=5Fio=5Fconcurrency= =3D 200 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 1-1000; 0 disables prefetc= hing
=23maintenance=5Fio=5Fconcurrency =3D 10 =C2=A0 =C2=A0 =C2= =A0 =C2=A0=23 1-1000; 0 disables prefetching
max=5Fworker=5Fpro= cesses =3D 16 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 (chang= e requires restart)
max=5Fparallel=5Fmaintenance=5Fworkers =3D = 4 =C2=A0 =C2=A0=23 taken from max=5Fparallel=5Fworkers
max=5Fpa= rallel=5Fworkers=5Fper=5Fgather =3D 4 =C2=A0 =C2=A0 =23 taken from max=5F= parallel=5Fworkers
=23parallel=5Fleader=5Fparticipation =3D on<= /div>
max=5Fparallel=5Fworkers =3D 16 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =23 maximum number of max=5Fworker=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=5Fthr= eshold =3D -1 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 1min-60d; -1 d= isables; 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 restart)
=23backe= nd=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=5Fleve= l =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
=C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =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)
=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 di= sk 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 cause
=C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =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 unrecoverabl= e data corruption)
=23synchronous=5Fcommit =3D on =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 synchronization 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=5Fsyn= c=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 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 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 L= inux)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =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=5Fwrites =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 w= rites
=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 wri= tes
=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 also 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 restart)
=23wal=5Fin= it=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=5Fbuffers =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 32= kB, -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=5Fthreshold =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-1000

= =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=5Fwal=5Fsize =3D 2GB
<= div>checkpoint=5Fcompletion=5Ftarget =3D 0.9 =C2=A0 =C2=A0 =C2=A0=23 chec= kpoint target duration, 0.0 - 1.0
=23checkpoint=5Fflush=5Fafter= =3D 256kB =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 measured in pages, 0 disables<= /div>
=23checkpoint=5Fwarning =3D 30s =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =23 0 disables

=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 (change 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
<= 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 =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/server/archivedir/%f &&a= mp; cp %p /mnt/server/archivedir/%f'
=23archive=5Ftimeout =3D 0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 force a logfile segment swi= tch 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 numbe= r 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 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 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/archi= vedir/%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 r= equires restart)
=23archive=5Fcleanup=5Fcommand =3D '' =C2=A0 =23= command to execute at every restartpoint
=23recovery=5Fend=5Fc= ommand =3D '' =C2=A0 =C2=A0 =C2=A0=23 command to execute at completion of= recovery

=23 - Recovery Target -

=
=23 Set these only when performing a targeted recovery.
<= div>
=23recovery=5Ftarget =3D '' =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =23 'immediate' to end recovery as soon as 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 requires restart)
=23recovery=5Ftarget=5Fname =3D '' =C2=A0 =C2=A0 =C2=A0=23 the named r= estore 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=5Ft= arget=5Ftime =3D '' =C2=A0 =C2=A0 =C2=A0=23 the time stamp up to which re= covery 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 (c= hange requires restart)
=23recovery=5Ftarget=5Fxid =3D '' =C2=A0= =C2=A0 =C2=A0 =23 the transaction ID 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 restar= t)
=23recovery=5Ftarget=5Flsn =3D '' =C2=A0 =C2=A0 =C2=A0 =23 t= he 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)
=23recovery=5Ft= arget=5Finclusive =3D on =23 Specifies whether to 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 the specified recovery tar= get (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)
=23recovery=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 (change 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)


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

=
=23 - Sending Servers -

=23 Set these= on the master and on any standby that will send replication data.
<= div>
=23max=5Fwal=5Fsenders =3D 10 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =23 max number of walsender processes
=C2=A0 =C2=A0 = =C2=A0 =C2=A0 =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=5F= keep=5Fsize =3D 0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 in = megabytes; 0 disables
=23max=5Fslot=5Fwal=5Fkeep=5Fsize =3D -1 = =C2=A0 =C2=A0=23 in megabytes; -1 disables
=23wal=5Fsender=5Fti= meout =3D 60s =C2=A0 =C2=A0 =C2=A0 =23 in milliseconds; 0 disables
<= div>
=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)
=23track=5Fcommit=5Ftimes= tamp =3D off =C2=A0 =23 collect timestamp of transaction 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 requires restart)

=23 - Master Server -

=23 T= hese settings are ignored on a standby server.

=23= synchronous=5Fstandby=5Fnames =3D '' =23 standby servers that provide syn= c 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 application=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 al= l
=23vacuum=5Fdefer=5Fcleanup=5Fage =3D 0 =C2=A0 =23 number of = xacts by which cleanup is delayed

=23 - Standby = Servers -

=23 These settings are ignored on a ma= ster server.

=23primary=5Fconninfo =3D '' =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 connection st= ring to sending server
=23primary=5Fslot=5Fname =3D '' =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 replication slot on sen= ding server
=23promote=5Ftrigger=5Ffile =3D '' =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 file name whose presence 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 du= ring 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=5Fstandb= y=5Farchive=5Fdelay =3D 30s =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 max delay befo= re 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 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 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 -1 al= lows 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 restart)
=23max=5F= sync=5Fworkers=5Fper=5Fsubscription =3D 2 =C2=A0=23 taken from max=5Flogi= cal=5Freplication=5Fworkers


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

=23 - Planner Method Configuration -

=23enable= =5Fbitmapscan =3D on
=23enable=5Fhashagg =3D on
=23en= able=5Fhashjoin =3D on
=23enable=5Findexscan =3D on
=23= enable=5Findexonlyscan =3D on
=23enable=5Fmaterial =3D on
=
=23enable=5Fmergejoin =3D on
=23enable=5Fnestloop =3D on
=23enable=5Fparallel=5Fappend =3D on
=23enable=5Fseqsc= an =3D on
=23enable=5Fsort =3D on
=23enable=5Fincreme= ntal=5Fsort =3D on
=23enable=5Ftidscan =3D on
=23enab= le=5Fpartitionwise=5Fjoin =3D off
=23enable=5Fpartitionwise=5Fa= ggregate =3D off
=23enable=5Fparallel=5Fhash =3D on
=23= enable=5Fpartition=5Fpruning =3D on

=23 - Planne= r Cost Constants -

=23seq=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=5Fpage=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
=23= cpu=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 scale as above
=23= parallel=5Ftuple=5Fcost =3D 0.1 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0=23 same scale as above
=23parallel=5Fsetup=5Fcost =3D 1= 000.0 =C2=A0 =23 same scale as above

=23jit=5Fab= ove=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 expensiv= e 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=5Finline=5Fabove=5Fcost =3D= 500000 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 inline small functions if query i= s
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =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 opt= imizations 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 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 disabl= es

=23min=5Fparallel=5Ftable=5Fscan=5Fsize =3D 8= MB
=23min=5Fparallel=5Findex=5Fscan=5Fsize =3D 512kB
= effective=5Fcache=5Fsize =3D 24GB

=23 - Genetic = Query Optimizer -

=23geqo =3D on
=23ge= qo=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 selects default based on effor= t
=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=5Fseed =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 - Other Planner Options -

=23default=5Fstatistics=5Ftarget =3D 100 =C2=A0 =C2= =A0 =C2=A0 =C2=A0=23 range 1-10000
=23constraint=5Fexclusion =3D= partition =C2=A0 =C2=A0 =C2=A0 =23 on, off, or partition
=23cu= rsor=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=5Flimit =3D 8
=23= join=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
=C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =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
<= div>=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 compilation
=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 LOGG= ING
=23--------------------------------------------------------= ----------------------

=23 - Where to Log -

=23log=5Fdestination =3D 'stderr' =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =23 Valid values are combinations 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, c= svlog, 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 ca= pturing 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 restart)

= =23 These are only used if logging=5Fcollector is on:
=23log=5F= directory =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 written,
=C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =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=5Ffilename =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
=23log=5Ffile=5Fmode =3D 06= 00 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 cre= ation 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 same name as the new lo= g 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 rotation, 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=A0 Default 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.
=23log=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 after that time. =C2=A0= 0 disables.
=23log=5Frotation=5Fsize =3D 10MB =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 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 disables.

=
=23 These are relevant when logging to syslog:
=23sy= slog=5Ffacility =3D 'LOCAL0'
=23syslog=5Fident =3D 'postgres'
=23syslog=5Fsequence=5Fnumbers =3D on
=23syslog=5Fspli= t=5Fmessages =3D on

=23 This is only relevant wh= en logging to eventlog (win32):
=23 (change requires restart)
=23event=5Fsource =3D 'PostgreSQL'

=23 = - When to Log -

=23log=5Fmin=5Fmessages =3D warn= ing =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 values in order of decr= easing 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 de= bug3
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =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 lo= g
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =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 value= s 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 debug= 4
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =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=5Fstatement =3D -1 =C2=A0= =C2=A0 =C2=A0 =C2=A0=23 -1 is disabled, 0 logs all 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 an= d 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 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

=23log=5Fmin=5Fdu= ration=5Fsample =3D -1 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 -1 is disab= led, 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 durations, > 0 lo= gs 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 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;
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =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=5Fstatemen= t=5Fsample=5Frate

=23log=5Fstatement=5Fsample=5F= rate =3D 1.0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 fraction of logged 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 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 1.= 0 logs all such statements, 0.0 never logs


<= /div>
=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 logged regardle= ss 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 transactio= ns, 0.0 never logs

=23 - What to Log -

=23debug=5Fprint=5Fparse =3D off
=23debug=5Fpri= nt=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=5Fv= erbosity =3D default =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 terse, default= , or verbose messages
=23log=5Fhostname =3D off
=23lo= g=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
=C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =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 remot= e 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 backe= nd 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 wi= thout 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 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 %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 se= ssion 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 se= ssion 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 transaction 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
=C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =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=5Flock=5Fwaits =3D= off =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 l= og lock waits >=3D deadlock=5Ftimeout
=23log=5Fparameter=5Fm= ax=5Flength =3D -1 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 when logging sta= tements, 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 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 in full, 0 disables
=23log=5Fparameter=5Fmax=5Flen= gth=5Fon=5Ferror =3D 0 =C2=A0=23 when logging an error, 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 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 in full, 0 disa= bles
=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=5Fre= plication=5Fcommands =3D off
=23log=5Ftemp=5Ffiles =3D -1 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 log te= mporary 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=5Ftimezone =3D '= UTC'

=23----------------------------------------= --------------------------------------
=23 PROCESS TITLE
<= div>=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 add= ed 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 restart)
=23update=5Fprocess=5Ftitle =3D on


=
=23-----------------------------------------------------------------= -------------
=23 STATISTICS
=23---------------------= ---------------------------------------------------------

<= /div>
=23 - Query and Index Statistics Collector -

=23track=5Factivities =3D on
=23track=5Fcounts =3D on
=23track=5Fio=5Ftiming =3D off
=23track=5Ffunctions =3D= none =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 none, p= l, all
=23track=5Factivity=5Fquery=5Fsize =3D 1024 =C2=A0 =C2=A0= =C2=A0 =23 (change requires restart)
=23stats=5Ftemp=5Fdirecto= ry =3D 'pg=5Fstat=5Ftmp'


=23 - Mo= nitoring -

=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 =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 autova= cuum 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 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 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 millis= econds.
=23autovacuum=5Fmax=5Fworkers =3D 3 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =23 max number of autovacuum subprocesses
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =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 (c= hange requires restart)
=23autovacuum=5Fnaptime =3D 1min =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 time between autovacuum run= s
=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 numbe= r 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=5F= vacuum=5Fscale=5Ffactor =3D 0.2 =C2=A0 =23 fraction of table size before = vacuum
=23autovacuum=5Fvacuum=5Finsert=5Fscale=5Ffactor =3D 0.2= =C2=A0 =C2=A0=23 fraction of inserts over table
=C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =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 inse= rt vacuum
=23autovacuum=5Fanalyze=5Fscale=5Ffactor =3D 0.1 =C2=A0= =23 fraction of table size before analyze
=23autovacuum=5Ffreez= e=5Fmax=5Fage =3D 200000000 =C2=A0=23 maximum XID age before forced vacuu= m
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =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=5Fmultixact=5Ff= reeze=5Fmax=5Fage =3D 400000000 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 maximum mu= ltixact 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 requires restart)<= /div>
=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 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 -1= means use vacuum=5Fcost=5Fdelay
=23autovacuum=5Fvacuum=5Fcost=5F= limit =3D -1 =C2=A0 =C2=A0 =C2=A0=23 default vacuum cost limit for
<= 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= 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 CONNECTION DE=46AULTS=
=23-----------------------------------------------------------= -------------------

=23 - Statement Behavior -

=23client=5Fmin=5Fmessages =3D notice =C2=A0 =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 debug= 2
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =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 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
=23search=5Fpath =3D '=22=24user=22= , public' =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 schema names
=23row=5F= security =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 tablespace names, '' use= s
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =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=5Fm= ethod =3D 'heap'
=23check=5Ffunction=5Fbodies =3D on
= =23default=5Ftransaction=5Fisolation =3D 'read committed'
=23de= fault=5Ftransaction=5Fread=5Fonly =3D off
=23default=5Ftransact= ion=5Fdeferrable =3D off
=23session=5Freplication=5Frole =3D 'o= rigin'
=23statement=5Ftimeout =3D 0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 in milliseconds, 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 milliseconds, 0 is disabled
=23idle=5Fin=5Ftransaction=5Fsession=5Ftimeout =3D 0 =C2=A0 =C2=A0= =C2=A0 =C2=A0=23 in milliseconds, 0 is disabled
=23vacuum=5Ffr= eeze=5Fmin=5Fage =3D 50000000
=23vacuum=5Ffreeze=5Ftable=5Fage = =3D 150000000
=23vacuum=5Fmultixact=5Ffreeze=5Fmin=5Fage =3D 50= 00000
=23vacuum=5Fmultixact=5Ffreeze=5Ftable=5Fage =3D 15000000= 0
=23vacuum=5Fcleanup=5Findex=5Fscale=5Ffactor =3D 0.1 =C2=A0 =C2= =A0 =C2=A0 =C2=A0=23 fraction of total number of tuples
=C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =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 performs
=C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =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
=23bytea=5Foutput =3D 'hex' =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 hex, esca= pe
=23xmlbinary =3D 'base64'
=23xmloption =3D 'conten= t'
=23gin=5Ffuzzy=5Fsearch=5Flimit =3D 0
=23gin=5Fpen= ding=5Flist=5Flimit =3D 4MB

=23 - Locale and =46= ormatting -

datestyle =3D 'iso, mdy'
=23= intervalstyle =3D 'postgres'
timezone =3D 'UTC'
=23ti= mezone=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=A0 Currently, 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 (historical 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 In= dia
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =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 value >0 actually
<= 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= selects precise output mode
=23client=5Fencoding =3D sql=5Fasc= ii =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 actually, defaults to dat= abase
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =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 init= ialized 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 message
=C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =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 locale for monetary formatt= ing
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 f= ormatting
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 loc= ale for time formatting

=23 default configuratio= n for text search
default=5Ftext=5Fsearch=5Fconfig =3D 'pg=5Fca= talog.english'

=23 - Shared Library Preloading -=

=23shared=5Fpreload=5Flibraries =3D '' =C2=A0=23= (change requires restart)
shared=5Fpreload=5Flibraries =3D 'pg= =5Fstat=5Fstatements'
pg=5Fstat=5Fstatements.track =3D all
=23local=5Fpreload=5Flibraries =3D ''
=23session=5Fpreloa= d=5Flibraries =3D ''
=23jit=5Fprovider =3D 'llvmjit' =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 JIT library to use
<= br>
=23 - Other Defaults -

=23dynamic=5F= library=5Fpath =3D '=24libdir'


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

=23deadlock=5Ftimeout =3D 1s
=23max=5Flocks=5Fper=5Ftran= saction =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 requ= ires restart)
=23max=5Fpred=5Flocks=5Fper=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=5F= pred=5Flocks=5Fper=5Frelation =3D -2 =C2=A0 =C2=A0 =C2=A0 =23 negative va= lues 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=5Ftransaction
=C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =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=5Fp= er=5Fpage =3D 2 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 min 0
<= div>

=23------------------------------------= ------------------------------------------
=23 VERSION AND PLAT= =46ORM COMPATIBILITY
=23---------------------------------------= ---------------------------------------

=23 - Pr= evious PostgreSQL Versions -

=23array=5Fnulls =3D= on
=23backslash=5Fquote =3D safe=5Fencoding =C2=A0 =C2=A0 =C2=A0= =C2=A0=23 on, off, or safe=5Fencoding
=23escape=5Fstring=5Fwar= ning =3D on
=23lo=5Fcompat=5Fprivileges =3D off
=23op= erator=5Fprecedence=5Fwarning =3D off
=23quote=5Fall=5Fidentifi= ers =3D off
=23standard=5Fconforming=5Fstrings =3D on
=23synchronize=5Fseqscans =3D on

=23 - Other Pl= atforms and Clients -

=23transform=5Fnull=5Fequa= ls =3D off


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

=23exit=5Fon=5F= error =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=5Faf= ter=5Fcrash =3D on =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =23 r= einitialize after backend crash=3F
=23data=5Fsync=5Fretry =3D o= ff =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=23 retr= y 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 data=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 restar= t)


=23---------------------------= ---------------------------------------------------
=23 CON=46I= G =46ILE INCLUDES
=23------------------------------------------= ------------------------------------

=23 These o= ptions allow settings to be loaded from files other than the
=23= default postgresql.conf.=C2=A0 Note that these are directives, not varia= ble
=23 assignments, so they can usefully be given more than on= ce.

=23include=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 end= ing 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'
=23includ= e=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

<= div id=3D=22gmail-m=5F6095832944157844737=22>


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


n= e 11. 10. 2020 v=C2=A03:13 odes=C3=ADlatel Raphael Megzari <raphael=40megz= ari.com> napsal:
ok here is the backtrace that I got

Let me know if you need anything else
=

please, can you install debug symb= ols for Postgres. In this backtrace is not detail information.
=
It's strange so Postgres crashes in LWLockAttemptLock


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

<= div>


=230 =C2=A00x0000556931d0ba= 55 in LWLockAttemptLock ()
=231 =C2=A00x0000556931d0c537 in LWL= ockAcquire ()
=232 =C2=A00x0000556931cefe83 in ReadBuffer=5Fcom= mon ()
=233 =C2=A00x0000556931cf0626 in ReadBufferExtended ()
=234 =C2=A00x0000556931a8c9b0 in heapgetpage ()
=235 =C2= =A00x0000556931a8cf09 in heapgettup=5Fpagemode ()
=236 =C2=A00x= 0000556931a8de3e in heap=5Fgetnextslot ()
=237 =C2=A00x00005569= 31bf27fe in SeqNext ()
=238 =C2=A00x0000556931bd15b7 in ExecSca= n ()
=239 =C2=A00x0000556931bf115f in ExecNestLoop ()
=2310 0x0000556931bf115f in ExecNestLoop ()
=2311 0x0000556931= be1147 in ExecGather ()
=2312 0x0000556931bc8a2b in standard=5F= ExecutorRun ()
=2313 0x00007f10dcb8d345 in pgss=5FExecutorRun (= ) from /usr/local/lib/postgresql/pg=5Fstat=5Fstatements.so
=231= 4 0x0000556931d1e41c in PortalRunSelect ()
=2315 0x0000556931d1= f5d6 in PortalRun ()
=2316 0x0000556931d1cb58 in PostgresMain (= )
=2317 0x0000556931caa3d7 in ServerLoop ()
=2318 0x0= 000556931cab333 in PostmasterMain ()
=2319 0x0000556931a4db7c i= n main ()




<= /div>
On Saturday, Oct 10, = 2020 at 11:57 PM, Pavel Stehule <pavel.stehule=40gmail.com> wro= te:

so 10. 10. 2020 v=C2=A016:51 odes=C3=ADlatel Raphael Megzari <= raph= ael=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.



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. 10. 2020 = v=C2=A013:27 odes=C3=ADlatel Raphael Megzari <raphael=40megzari.com>= ; napsal:
<= div id=3D=22gmail-m=5F6095832944157844737gmail-m=5F-2314157496917721044gm= ail-m=5F-7223954153812132341gmail-m=5F-6563864094213541086=22>
Awes= ome, thank you=21
It's the right thing.

How do I share it=3F

= important is the backtrace

paste it to mail



<= br>

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

<= /div>
so 10. 10. 2020 v=C2=A013:19 odes=C3=ADlatel Raphael Megz= ari <raphael=40megzari.com> napsal:
Thank 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 wi= th pg=5Fctl anc a =22c=22 flag. I couldn't find anything on enabling it o= n 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

<= /div>
you can check a create time

Pavel


Raphael

<= div>


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


If I can help in any ways, please let= me know.
I don't mind trying things, like I said, the bug happens ab= out 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

=
--5f851f8c_643c9869_ebc6--