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 1kSFJO-0006KJ-Dh for pgsql-bugs@arkaria.postgresql.org; Tue, 13 Oct 2020 08:05:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kSFJN-0003BO-CT for pgsql-bugs@arkaria.postgresql.org; Tue, 13 Oct 2020 08:05:33 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kSBbX-0005yH-CJ for pgsql-bugs@lists.postgresql.org; Tue, 13 Oct 2020 04:08:03 +0000 Received: from [66.111.4.25] (helo=out1-smtp.messagingengine.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kSBbR-0000h7-FB for pgsql-bugs@lists.postgresql.org; Tue, 13 Oct 2020 04:08:02 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.42]) by mailout.nyi.internal (Postfix) with ESMTP id 077505C016A; Tue, 13 Oct 2020 00:07:46 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute2.internal (MEProxy); Tue, 13 Oct 2020 00:07:46 -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=LTf+zc aMzBD4jXPH2QmtgATaBoeoi8KdDwcpPHgA2tA=; b=PRGxns3DOPmTjU+6a7aLxB awUowJXapXpSyw+JPR6DgA3go1BXxiT49tI/MVkcvuPnhVf0W56APEOgdo25xTEy OT2pKX38YOr3QxnOrox/lQ5POksbXg1pYejlL3aP4dLEE08olxVFfUFCPsJg+7V/ We7bZO/LH1jfvQjNC0XEqH9gUpM5+1Or5FlnHrf3K26ljuozmyL6rRYTyOc2jxtO p+Xjm4ls14Cbh2PJgMBxDv81ouS+WqDGonOo0s35xb37ihyAczdI2a8WwAxWxr3z eVzDH3s8YDiiYdl2v2dZSv9vl1kHpHApuxCu1RtVE36LzaQMLEnFaYw3vskEVyKw == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedujedrheekgdekudcutefuodetggdotefrodftvf 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 B37D0306467D; Tue, 13 Oct 2020 00:07:42 -0400 (EDT) Date: Tue, 13 Oct 2020 13:07:40 +0900 From: Raphael Megzari To: Pavel Stehule Cc: PostgreSQL mailing lists , Thomas Munro Message-ID: <16aeb6fe-a202-461e-ae0b-16bf65f17e0b@Canary> 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="5f85280c_2ae8944a_ebc6" X-Host-Lookup-Failed: Reverse DNS lookup failed for 66.111.4.25 (deferred) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --5f85280c_2ae8944a_ebc6 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline The problem is that I don't know how to make it fails. I know that on my production server it fails randomly every two days. Would it help more if I tried to get a backtrace with =60bt full=60 rathe= r than just =60bt=60 like I did with the previous one=3F I'm not sure how to move this forwad further. > On Tuesday, Oct 13, 2020 at 12:38 PM, Pavel Stehule wrote: > > > =C3=BAt 13. 10. 2020 v 5:31 odes=C3=ADlatel Raphael Megzari napsal: > > 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 bui= lt 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 Th= ose binaries are different but come from the same version of postgres, wo= uld that work=3F > > > > You cannot use binaries for docker for macOS. But if your application f= ails inside the image, then probably it fails on macOS too. > > Regards > > Pavel > > > > > > > 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 po= int me to the right resource, I can read it. > > > > > > it is a separate package - it has no relation to Postgres configura= tion. > > > > > > maybe this thread is related https://github.com/docker-library/post= gres/issues/666 > > > > > > Pavel > > > > > > > > > > > Here is my full configuration file. I haven't changed so many val= ues > > > > > > > > =23--------------------------------------------------------------= ---------------- > > > > =23 =46ILE LOCATIONS > > > > =23--------------------------------------------------------------= ---------------- > > > > > > > > =23 The default values of these variables are driven from the -D = command-line > > > > =23 option or PGDATA environment variable, represented here as Co= nfigDir. > > > > > > > > =23data=5Fdirectory =3D 'ConfigDir' =23 use data in another direc= tory > > > > =23 (change requires restart) > > > > =23hba=5Ffile =3D 'ConfigDir/pg=5Fhba.conf' =23 host-based authen= tication file > > > > =23 (change requires restart) > > > > =23ident=5Ffile =3D 'ConfigDir/pg=5Fident.conf' =23 ident configu= ration 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 = restart) > > > > =23unix=5Fsocket=5Fdirectories =3D '/var/run/postgresql' =23 comm= a-separated 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 o= ctal 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 seco= nds; > > > > =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 millis= econds; > > > > =23 0 selects the system default > > > > > > > > =23 - Authentication - > > > > > > > > =23authentication=5Ftimeout =3D 1min =23 1s-600s > > > > =23password=5Fencryption =3D md5 =23 md5 or scram-sha-256 > > > > =23db=5Fuser=5Fnamespace =3D off > > > > > > > > =23 GSSAPI using Kerberos > > > > =23krb=5Fserver=5Fkeyfile =3D '' > > > > =23krb=5Fcaseins=5Fusers =3D off > > > > > > > > =23 - SSL - > > > > > > > > =23ssl =3D off > > > > =23ssl=5Fca=5Ffile =3D '' > > > > =23ssl=5Fcert=5Ffile =3D 'server.crt' > > > > =23ssl=5Fcrl=5Ffile =3D '' > > > > =23ssl=5Fkey=5Ffile =3D 'server.key' > > > > =23ssl=5Fciphers =3D 'HIGH:MEDIUM:+3DES:=21aNULL' =23 allowed SSL= ciphers > > > > =23ssl=5Fprefer=5Fserver=5Fciphers =3D on > > > > =23ssl=5Fecdh=5Fcurve =3D 'prime256v1' > > > > =23ssl=5Fmin=5Fprotocol=5Fversion =3D 'TLSv1.2' > > > > =23ssl=5Fmax=5Fprotocol=5Fversion =3D '' > > > > =23ssl=5Fdh=5Fparams=5Ffile =3D '' > > > > =23ssl=5Fpassphrase=5Fcommand =3D '' > > > > =23ssl=5Fpassphrase=5Fcommand=5Fsupports=5Freload =3D off > > > > > > > > > > > > =23--------------------------------------------------------------= ---------------- > > > > =23 RESOURCE USAGE (except WAL) > > > > =23--------------------------------------------------------------= ---------------- > > > > > > > > =23 - Memory - > > > > > > > > shared=5Fbuffers =3D 8GB =23 min 128kB > > > > =23 (change requires restart) > > > > =23huge=5Fpages =3D try =23 on, off, or try > > > > =23 (change requires restart) > > > > =23temp=5Fbuffers =3D 8MB =23 min 800kB > > > > =23max=5Fprepared=5Ftransactions =3D 0 =23 zero disables the feat= ure > > > > =23 (change requires restart) > > > > =23 Caution: it is not advisable to set max=5Fprepared=5Ftransact= ions 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 has= h table work=5Fmem > > > > maintenance=5Fwork=5Fmem =3D 2GB =23 min 1MB > > > > =23autovacuum=5Fwork=5Fmem =3D -1 =23 min 1MB, or -1 to use maint= enance=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 o= ption > > > > =23 supported by the operating system: > > > > =23 mmap > > > > =23 sysv > > > > =23 windows > > > > =23 (change requires restart) > > > > dynamic=5Fshared=5Fmemory=5Ftype =3D posix =23 the default is the= first 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 sp= ace > > > > =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/roun= d, 0 disables > > > > =23bgwriter=5Flru=5Fmultiplier =3D 2.0 =23 0-10.0 multiplier on b= uffers scanned/round > > > > =23bgwriter=5Fflush=5Fafter =3D 512kB =23 measured in pages, 0 di= sables > > > > > > > > =23 - Asynchronous Behavior - > > > > > > > > effective=5Fio=5Fconcurrency =3D 200 =23 1-1000; 0 disables prefe= tching > > > > =23maintenance=5Fio=5Fconcurrency =3D 10 =23 1-1000; 0 disables p= refetching > > > > max=5Fworker=5Fprocesses =3D 16 =23 (change requires restart) > > > > max=5Fparallel=5Fmaintenance=5Fworkers =3D 4 =23 taken from max=5F= parallel=5Fworkers > > > > max=5Fparallel=5Fworkers=5Fper=5Fgather =3D 4 =23 taken from max=5F= parallel=5Fworkers > > > > =23parallel=5Fleader=5Fparticipation =3D on > > > > max=5Fparallel=5Fworkers =3D 16 =23 maximum number of max=5Fworke= r=5Fprocesses 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 disable= s > > > > > > > > > > > > =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 opt= ion > > > > =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 writ= es > > > > =23wal=5Fcompression =3D off =23 enable compression of full-page = writes > > > > =23wal=5Flog=5Fhints =3D off =23 also do full page writes of non-= critical updates > > > > =23 (change requires restart) > > > > =23wal=5Finit=5Fzero =3D on =23 zero-fill new WAL files > > > > =23wal=5Frecycle =3D on =23 recycle WAL files > > > > wal=5Fbuffers =3D 16MB =23 min 32kB, -1 sets based on shared=5Fbu= ffers > > > > =23 (change requires restart) > > > > =23wal=5Fwriter=5Fdelay =3D 200ms =23 1-10000 milliseconds > > > > =23wal=5Fwriter=5Fflush=5Fafter =3D 1MB =23 measured in pages, 0 = disables > > > > =23wal=5Fskip=5Fthreshold =3D 2MB > > > > > > > > =23commit=5Fdelay =3D 0 =23 range 0-100000, in microseconds > > > > =23commit=5Fsiblings =3D 5 =23 range 1-1000 > > > > > > > > =23 - Checkpoints - > > > > > > > > =23checkpoint=5Ftimeout =3D 5min =23 range 30s-1d > > > > max=5Fwal=5Fsize =3D 8GB > > > > min=5Fwal=5Fsize =3D 2GB > > > > checkpoint=5Fcompletion=5Ftarget =3D 0.9 =23 checkpoint target du= ration, 0.0 - 1.0 > > > > =23checkpoint=5Fflush=5Fafter =3D 256kB =23 measured in pages, 0 = disables > > > > =23checkpoint=5Fwarning =3D 30s =23 0 disables > > > > > > > > =23 - Archiving - > > > > > > > > =23archive=5Fmode =3D off =23 enables archiving; off, on, or alwa= ys > > > > =23 (change requires restart) > > > > =23archive=5Fcommand =3D '' =23 command to use to archive a logfi= le segment > > > > =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/ser= ver/archivedir/%f' > > > > =23archive=5Ftimeout =3D 0 =23 force a logfile segment switch aft= er this > > > > =23 number of seconds; 0 disables > > > > > > > > =23 - Archive Recovery - > > > > > > > > =23 These are only used in recovery mode. > > > > > > > > =23restore=5Fcommand =3D '' =23 command to use to restore an arch= ived 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 e= very restartpoint > > > > =23recovery=5Fend=5Fcommand =3D '' =23 command to execute at comp= letion of recovery > > > > > > > > =23 - Recovery Target - > > > > > > > > =23 Set these only when performing a targeted recovery. > > > > > > > > =23recovery=5Ftarget =3D '' =23 'immediate' to end recovery as so= on as a > > > > =23 consistent state is reached > > > > =23 (change requires restart) > > > > =23recovery=5Ftarget=5Fname =3D '' =23 the named restore point to= which recovery will proceed > > > > =23 (change requires restart) > > > > =23recovery=5Ftarget=5Ftime =3D '' =23 the time stamp up to which= recovery will proceed > > > > =23 (change requires restart) > > > > =23recovery=5Ftarget=5Fxid =3D '' =23 the transaction ID up to wh= ich recovery will proceed > > > > =23 (change requires restart) > > > > =23recovery=5Ftarget=5Flsn =3D '' =23 the WAL LSN up to which rec= overy 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', 'late= st', or timeline ID > > > > =23 (change requires restart) > > > > =23recovery=5Ftarget=5Faction =3D 'pause' =23 'pause', 'promote',= 'shutdown' > > > > =23 (change requires restart) > > > > > > > > > > > > =23--------------------------------------------------------------= ---------------- > > > > =23 REPLICATION > > > > =23--------------------------------------------------------------= ---------------- > > > > > > > > =23 - Sending Servers - > > > > > > > > =23 Set these on the master and on any standby that will send rep= lication data. > > > > > > > > =23max=5Fwal=5Fsenders =3D 10 =23 max number of walsender process= es > > > > =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 dis= ables > > > > =23wal=5Fsender=5Ftimeout =3D 60s =23 in milliseconds; 0 disables= > > > > > > > > =23max=5Freplication=5Fslots =3D 10 =23 max number of replication= slots > > > > =23 (change requires restart) > > > > =23track=5Fcommit=5Ftimestamp =3D off =23 collect timestamp of tr= ansaction commit > > > > =23 (change requires restart) > > > > > > > > =23 - Master Server - > > > > > > > > =23 These settings are ignored on a standby server. > > > > > > > > =23synchronous=5Fstandby=5Fnames =3D '' =23 standby servers that = provide sync rep > > > > =23 method to choose sync standbys, number of sync standbys, > > > > =23 and comma-separated list of application=5Fname > > > > =23 from standby(s); '*' =3D all > > > > =23vacuum=5Fdefer=5Fcleanup=5Fage =3D 0 =23 number of xacts by wh= ich cleanup is delayed > > > > > > > > =23 - Standby Servers - > > > > > > > > =23 These settings are ignored on a master server. > > > > > > > > =23primary=5Fconninfo =3D '' =23 connection string to sending ser= ver > > > > =23primary=5Fslot=5Fname =3D '' =23 replication slot on sending s= erver > > > > =23promote=5Ftrigger=5Ffile =3D '' =23 file name whose presence e= nds recovery > > > > =23hot=5Fstandby =3D on =23 =22off=22 disallows queries during re= covery > > > > =23 (change requires restart) > > > > =23max=5Fstandby=5Farchive=5Fdelay =3D 30s =23 max delay before c= anceling 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 a= vailable > > > > =23 and query more expensive than this; > > > > =23 -1 disables > > > > =23jit=5Finline=5Fabove=5Fcost =3D 500000 =23 inline small functi= ons if query is > > > > =23 more expensive than this; -1 disables > > > > =23jit=5Foptimize=5Fabove=5Fcost =3D 500000 =23 use expensive JIT= optimizations 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 exp= licit > > > > =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 combinatio= ns of > > > > =23 stderr, csvlog, syslog, and eventlog, > > > > =23 depending on platform. csvlog > > > > =23 requires logging=5Fcollector to be on. > > > > > > > > =23 This is used when logging to stderr: > > > > =23logging=5Fcollector =3D off =23 Enable capturing of stderr and= csvlog > > > > =23 into log files. Required to be on for > > > > =23 csvlogs. > > > > =23 (change requires restart) > > > > > > > > =23 These are only used if logging=5Fcollector is on: > > > > =23log=5Fdirectory =3D 'log' =23 directory where log files are wr= itten, > > > > =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= will > > > > =23 happen after that time. 0 disables. > > > > =23log=5Frotation=5Fsize =3D 10MB =23 Automatic rotation of logfi= les 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 decrea= sing 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= 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 (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 log= s 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=5Fr= ate > > > > > > > > =23log=5Fstatement=5Fsample=5Frate =3D 1.0 =23 fraction of logged= statements 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 tran= sactions 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 ver= bose 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=5F= timeout > > > > =23log=5Fparameter=5Fmax=5Flength =3D -1 =23 when logging stateme= nts, 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 log= ging 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 lar= ger > > > > =23 than the specified size in kilobytes; > > > > =23 -1 disables, 0 logs all temp files > > > > log=5Ftimezone =3D 'UTC' > > > > > > > > =23--------------------------------------------------------------= ---------------- > > > > =23 PROCESS TITLE > > > > =23--------------------------------------------------------------= ---------------- > > > > > > > > =23cluster=5Fname =3D '' =23 added to process titles if nonempty > > > > =23 (change requires restart) > > > > =23update=5Fprocess=5Ftitle =3D on > > > > > > > > > > > > =23--------------------------------------------------------------= ---------------- > > > > =23 STATISTICS > > > > =23--------------------------------------------------------------= ---------------- > > > > > > > > =23 - Query and Index Statistics Collector - > > > > > > > > =23track=5Factivities =3D on > > > > =23track=5Fcounts =3D on > > > > =23track=5Fio=5Ftiming =3D off > > > > =23track=5Ffunctions =3D none =23 none, pl, all > > > > =23track=5Factivity=5Fquery=5Fsize =3D 1024 =23 (change requires = restart) > > > > =23stats=5Ftemp=5Fdirectory =3D 'pg=5Fstat=5Ftmp' > > > > > > > > > > > > =23 - Monitoring - > > > > > > > > =23log=5Fparser=5Fstats =3D off > > > > =23log=5Fplanner=5Fstats =3D off > > > > =23log=5Fexecutor=5Fstats =3D off > > > > =23log=5Fstatement=5Fstats =3D off > > > > > > > > > > > > =23--------------------------------------------------------------= ---------------- > > > > =23 AUTOVACUUM > > > > =23--------------------------------------------------------------= ---------------- > > > > > > > > =23autovacuum =3D on =23 Enable autovacuum subprocess=3F 'on' > > > > =23 requires track=5Fcounts to also be on. > > > > =23log=5Fautovacuum=5Fmin=5Fduration =3D -1 =23 -1 disables, 0 lo= gs all 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 = subprocesses > > > > =23 (change requires restart) > > > > =23autovacuum=5Fnaptime =3D 1min =23 time between autovacuum runs= > > > > =23autovacuum=5Fvacuum=5Fthreshold =3D 50 =23 min number of row u= pdates before > > > > =23 vacuum > > > > =23autovacuum=5Fvacuum=5Finsert=5Fthreshold =3D 1000 =23 min numb= er of row inserts > > > > =23 before vacuum; -1 disables insert > > > > =23 vacuums > > > > =23autovacuum=5Fanalyze=5Fthreshold =3D 50 =23 min number of row = updates before > > > > =23 analyze > > > > =23autovacuum=5Fvacuum=5Fscale=5Ffactor =3D 0.2 =23 fraction of t= able size before vacuum > > > > =23autovacuum=5Fvacuum=5Finsert=5Fscale=5Ffactor =3D 0.2 =23 frac= tion of inserts over table > > > > =23 size before insert vacuum > > > > =23autovacuum=5Fanalyze=5Fscale=5Ffactor =3D 0.1 =23 fraction of = table 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 = maximum 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 c= ost 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 decr= easing 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= default > > > > =23temp=5Ftablespaces =3D '' =23 a list of tablespace names, '' u= ses > > > > =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 milli= seconds, 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 a= vailable time zone > > > > =23 abbreviations. Currently, there are > > > > =23 Default > > > > =23 Australia (historical usage) > > > > =23 India > > > > =23 You can create your own file in > > > > =23 share/timezonesets/. > > > > =23extra=5Ffloat=5Fdigits =3D 1 =23 min -15, max 3; any value >0 = actually > > > > =23 selects precise output mode > > > > =23client=5Fencoding =3D sql=5Fascii =23 actually, defaults to da= tabase > > > > =23 encoding > > > > > > > > =23 These settings are initialized by initdb, but they can be cha= nged. > > > > lc=5Fmessages =3D 'en=5FUS.utf8' =23 locale for system error mess= age > > > > =23 strings > > > > lc=5Fmonetary =3D 'en=5FUS.utf8' =23 locale for monetary formatti= ng > > > > 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 resta= rt) > > > > shared=5Fpreload=5Flibraries =3D 'pg=5Fstat=5Fstatements' > > > > pg=5Fstat=5Fstatements.track =3D all > > > > =23local=5Fpreload=5Flibraries =3D '' > > > > =23session=5Fpreload=5Flibraries =3D '' > > > > =23jit=5Fprovider =3D 'llvmjit' =23 JIT library to use > > > > > > > > =23 - Other Defaults - > > > > > > > > =23dynamic=5Flibrary=5Fpath =3D '=24libdir' > > > > > > > > > > > > =23--------------------------------------------------------------= ---------------- > > > > =23 LOCK MANAGEMENT > > > > =23--------------------------------------------------------------= ---------------- > > > > > > > > =23deadlock=5Ftimeout =3D 1s > > > > =23max=5Flocks=5Fper=5Ftransaction =3D 64 =23 min 10 > > > > =23 (change requires restart) > > > > =23max=5Fpred=5Flocks=5Fper=5Ftransaction =3D 64 =23 min 10 > > > > =23 (change requires restart) > > > > =23max=5Fpred=5Flocks=5Fper=5Frelation =3D -2 =23 negative values= mean > > > > =23 (max=5Fpred=5Flocks=5Fper=5Ftransaction > > > > =23 / -max=5Fpred=5Flocks=5Fper=5Frelation) - 1 > > > > =23max=5Fpred=5Flocks=5Fper=5Fpage =3D 2 =23 min 0 > > > > > > > > > > > > =23--------------------------------------------------------------= ---------------- > > > > =23 VERSION AND PLAT=46ORM COMPATIBILITY > > > > =23--------------------------------------------------------------= ---------------- > > > > > > > > =23 - Previous PostgreSQL Versions - > > > > > > > > =23array=5Fnulls =3D on > > > > =23backslash=5Fquote =3D safe=5Fencoding =23 on, off, or safe=5Fe= ncoding > > > > =23escape=5Fstring=5Fwarning =3D on > > > > =23lo=5Fcompat=5Fprivileges =3D off > > > > =23operator=5Fprecedence=5Fwarning =3D off > > > > =23quote=5Fall=5Fidentifiers =3D off > > > > =23standard=5Fconforming=5Fstrings =3D on > > > > =23synchronize=5Fseqscans =3D on > > > > > > > > =23 - Other Platforms and Clients - > > > > > > > > =23transform=5Fnull=5Fequals =3D off > > > > > > > > > > > > =23--------------------------------------------------------------= ---------------- > > > > =23 ERROR HANDLING > > > > =23--------------------------------------------------------------= ---------------- > > > > > > > > =23exit=5Fon=5Ferror =3D off =23 terminate session on any error=3F= > > > > =23restart=5Fafter=5Fcrash =3D on =23 reinitialize after backend = crash=3F > > > > =23data=5Fsync=5Fretry =3D off =23 retry or panic on failure to f= sync > > > > =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 th= an the > > > > =23 default postgresql.conf. Note that these are directives, not = variable > > > > =23 assignments, so they can usefully be given more than once. > > > > > > > > =23include=5Fdir =3D '...' =23 include files ending in '.conf' fr= om > > > > =23 a directory, e.g., 'conf.d' > > > > =23include=5Fif=5Fexists =3D '...' =23 include file only if it ex= ists > > > > =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 bac= ktrace is not detail information. > > > > > > > > > > It's strange so Postgres crashes in LWLockAttemptLock > > > > > > > > > > Maybe there is problem in https://github.com/postgres/postgres/= commit/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/l= ocal/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=5F= dump.gz > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > this is not good idea > > > > > > > > > > > > > > see https://stackoverflow.com/questions/5115613/core-dump-f= ile-analysis > > > > > > > > > > > > > > Pavel > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > it's 2GB > > > > > > > > > > > > > > > > If you have a link to a documentation of how I can read t= hat 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 Meg= zari napsal: > > > > > > > > > > > > Thank you for taking the time to have a look. > > > > > > > > > > > > > > > > > > > > > > > > I'm not sure how to enable core dump with the doc= ker image. > > > > > > > > > > > > > > > > > > > > > > > > I've seen some documentation where the db is star= ted with pg=5Fctl anc a =22c=22 flag. I couldn't find anything on enablin= g it on the docker image. > > > > > > > > > > > > > > > > > > > > > > > > in my data folder, I have a huge core file (8 GB)= . Would it be possible that it is the core dump file generated after the = segfault=3F > > > > > > > > > > > > > > > > > > > > > > you can check a create time > > > > > > > > > > > > > > > > > > > > > > Pavel > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Raphael > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On Saturday, Oct 10, 2020 at 6:04 PM, Pavel Ste= hule 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 p= ossible to detect any information. > > > > > > > > > > > > > > > > > > > > > > > > > > Can you enable core dump generating, and can yo= u send a core dump=3F > > > > > > > > > > > > > > > > > > > > > > > > > > Regards > > > > > > > > > > > > > > > > > > > > > > > > > > Pavel > > > > > > > > > > > > > > > > > > > > > > > > > > > > Cheers=21 > > > > > > > > > > > > > > --5f85280c_2ae8944a_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>
=
The problem is that I don't know how to make it fails.
<= br>
I know that on my production server it fails randomly every= two days.

Would it help more if I tried to get = a backtrace with =60bt full=60 rather than just =60bt=60 like I did with = the previous one=3F

I'm not sure how to move thi= s forwad further.

=


On Tuesday, Oct 13, 2020 at 12:38 PM, Pav= el Stehule <pavel.ste= hule=40gmail.com> wrote:


=C3=BAt 13. 10. 2020 v=C2=A05:31 ode= s=C3=ADlatel Raphael Megzari <raphael=40megzari.com> napsal:
=
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


You cannot use binaries for docker for macOS. But if your applicati= on fails inside the image, then probably it fails on macOS too.

Regards

Pavel
=C2=A0


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


ne 11. 10. 2020 v=C2=A08:54 odes= =C3=ADlatel Raphael Megzari <raphael=40megzari.com> napsal:
I'm not sure how to install debug symbols for Postgres, if you point m= e to the right resource, I can read it.

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

maybe this thread is related https://github.com/docker-library/postgres/issues/666<= /a>

Pavel


H= ere is my full configuration file. I haven't changed so many values
=

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

=23 The default values of these varia= bles are driven from the -D command-line
=23 option or PGDATA e= nvironment variable, represented here as ConfigDir.

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

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


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

=23= - Connection Settings -

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

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

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

=23 - Authentication -
=

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

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

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


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

=23 - Memory -

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

=23 - Disk -

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

=23 - Kernel Reso= urces -

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

=23 - Cost-Based Vacuum Delay -

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

=23 - Background Writer -

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

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


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

=23 - Settings -

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

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

=23 - Checkpoints -

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

<= /div>
=23 - Archiving -

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

=23= - Archive Recovery -

=23 These are only used in= recovery mode.

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

=23 - Recovery = Target -

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

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

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

=23 - Sending Servers -

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

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

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

=23 - Master Server -

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

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

=23 - Standby Servers -

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

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


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

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

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

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

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

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

=23 - Oth= er Planner Options -

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


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

= =23 - Where to Log -

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

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

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

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

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

=23 - When to Log -

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

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

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

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


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

=23 - What to L= og -

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

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

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

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

=23 - Query and Index Statistics Collector -

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


=
=23 - Monitoring -

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

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

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


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

=23 - State= ment Behavior -

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

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

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

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

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

=23 - Sha= red Library Preloading -

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

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

<= /div>

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

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


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

=23 - Previous PostgreSQL Versions -

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

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


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

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


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

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

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


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

=23 Add settings for extensions here



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


ne 11. 10. 2020 v=C2= =A03:13 odes=C3=ADlatel Raphael Megzari <raphael=40megzari.com> naps= al:
ok here is the backtrace that I got

Let me kn= ow 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 Po= stgres crashes in LWLockAttemptLock


Do you use serializable level of transa= ction isolations=3F




=230 =C2=A00x0000556931d0ba55 i= n LWLockAttemptLock ()
=231 =C2=A00x0000556931d0c537 in LWLockA= cquire ()
=232 =C2=A00x0000556931cefe83 in ReadBuffer=5Fcommon = ()
=233 =C2=A00x0000556931cf0626 in ReadBufferExtended ()
=
=234 =C2=A00x0000556931a8c9b0 in heapgetpage ()
=235 =C2=A0= 0x0000556931a8cf09 in heapgettup=5Fpagemode ()
=236 =C2=A00x000= 0556931a8de3e in heap=5Fgetnextslot ()
=237 =C2=A00x0000556931b= f27fe in SeqNext ()
=238 =C2=A00x0000556931bd15b7 in ExecScan (= )
=239 =C2=A00x0000556931bf115f in ExecNestLoop ()
=23= 10 0x0000556931bf115f in ExecNestLoop ()
=2311 0x0000556931be11= 47 in ExecGather ()
=2312 0x0000556931bc8a2b in standard=5FExec= utorRun ()
=2313 0x00007f10dcb8d345 in pgss=5FExecutorRun () fr= om /usr/local/lib/postgresql/pg=5Fstat=5Fstatements.so
=2314 0x= 0000556931d1e41c in PortalRunSelect ()
=2315 0x0000556931d1f5d6= in PortalRun ()
=2316 0x0000556931d1cb58 in PostgresMain ()
=2317 0x0000556931caa3d7 in ServerLoop ()
=2318 0x00005= 56931cab333 in PostmasterMain ()
=2319 0x0000556931a4db7c in ma= in ()




On Satur= day, Oct 10, 2020 at 11:57 PM, Pavel Stehule <pavel.stehule=40gmail.co= m> wrote:


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

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



Pavel



= it's =C2=A02GB

If you have a link to a documenta= tion 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=40= gmail.com> wrote:


so 10. 10. 2020 v=C2=A013:27 odes=C3=ADlatel = Raphael Megzari <raphael=40megzari.com> napsal:
Awesome, thank you=21
It's the right th= ing.

How do I share it=3F

important is the backtrace

paste it to mail





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

Th= ank you for taking the time to have a look.

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

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

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

= you can check a create time

Pavel

=

Raphael




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


= If I can help in any ways, please let me know.
I don't mind trying t= hings, like I said, the bug happens about every 2
days.

This is a bug, but from your bug report isn't poss= ible to detect any information.

Can you en= able core dump generating, and can you send a core dump=3F

=
Regards

Pavel

Cheers=21

=
<= /div>
=
--5f85280c_2ae8944a_ebc6--