Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vw04L-00EkMf-18 for pgsql-general@arkaria.postgresql.org; Fri, 27 Feb 2026 15:47:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vw04J-004XgK-2q for pgsql-general@arkaria.postgresql.org; Fri, 27 Feb 2026 15:47:55 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vw04I-004Xg1-3D for pgsql-general@lists.postgresql.org; Fri, 27 Feb 2026 15:47:55 +0000 Received: from fhigh-a4-smtp.messagingengine.com ([103.168.172.155]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1vw04E-00000001am6-2PZG for pgsql-general@lists.postgresql.org; Fri, 27 Feb 2026 15:47:54 +0000 Received: from phl-compute-02.internal (phl-compute-02.internal [10.202.2.42]) by mailfhigh.phl.internal (Postfix) with ESMTP id 7B34E1400229; Fri, 27 Feb 2026 10:47:48 -0500 (EST) Received: from phl-frontend-03 ([10.202.2.162]) by phl-compute-02.internal (MEProxy); Fri, 27 Feb 2026 10:47:48 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:content-transfer-encoding:content-type:content-type:date:date :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm2; t=1772207268; x=1772293668; bh=TjENUyYWiccciB3JUJHI4dbpsjLPjgW7yC+gDNEWBZs=; b= eLM6VoSQ9Ou8/Zr65JXqzN5yVSqltyp6f/8wCs0R0VK73SshgQt90DalYfffFJTA QK56499gPERJurMEptLxw3exAtsG7fKDRa+uh+CzDoxTxGmLGzHsF5+t2ZPsR3Ra 3ZqcWKy1Yesb5s8ULSfgM6ObBjTWbGFXwrhHTKEolY6kPZzLxXJPHyh5W/yw0F/s PIFJHTJ4CfXSt1R4Mpahdw4U2yqr/Lr5a9eCf63xK/En9bjb8WvN9NP7Ok0BjB0u yF8j3He3cvRjr5X/RoyiplUPTwRPIEcGfntVurY+VVauE0XI4kRz3bu+Tg3W4a0J B1RGSjiaCeY5yMlExPG5Rg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm3; t=1772207268; x=1772293668; bh=T jENUyYWiccciB3JUJHI4dbpsjLPjgW7yC+gDNEWBZs=; b=RW08ZnR19lqXPjFTY 9N3eYiu1nwpiz4g7rYnGSAqqDzvzrplUUj6bEbXk/PjDAzIHIVhHcwfu4Ij4owGa /DV7sIkwqdKCZGCMx4Rst/aYPQDodx+vbOKOnivuP2FbJ4pPTjomV7ztlVswB99l AnvGSsZsnSwsVVka0KhBvEkgOwZG5znt+VDfqM2ld7s51aDhnoXAqMt1AUn5DdLr volLfkUfdLAdnkKSP74U4V0ARW1gbpuRttKCKLszEmlf+GUjw6QVL7z9QF72jYHx cVeynF7OGkJzVq7+Pe3rTF+8Y89JElkw/YlKam9WO0lz/zj8Ns5OTU+jPn8PmCyU 0Fk5Q== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefgedrtddtgddvgeelgedtucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu rghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnecujf gurhepkfffgggfuffvfhfhjggtgfesthejredttddvjeenucfhrhhomheptegurhhirghn ucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhmqe enucggtffrrghtthgvrhhnpeekfeehuddvjeeigfeifeejtdduudffledvfeelheeftdei ffeugfdvkeelgedtvdenucffohhmrghinhepphhoshhtghhrvghsqhhlrdhorhhgnecuve hluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprggurhhirghn rdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomhdpnhgspghrtghpthhtohepvddpmhhoug gvpehsmhhtphhouhhtpdhrtghpthhtohepihhkohhrohhttddusehgmhgrihhlrdgtohhm pdhrtghpthhtohepphhgshhqlhdqghgvnhgvrhgrlheslhhishhtshdrphhoshhtghhrvg hsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 27 Feb 2026 10:47:47 -0500 (EST) Message-ID: <12ca1b36-1933-4775-954c-90f870fb6dd0@aklaver.com> Date: Fri, 27 Feb 2026 07:47:47 -0800 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Default values in the docs To: Igor Korot , "pgsql-generallists.postgresql.org" References: Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2/26/26 10:43 PM, Igor Korot wrote: > Hi, ALL, > The page at https://www.postgresql.org/docs/current/sql-createtable.html#SQL-CREATETABLE-STORAGE-PARAMETERS > does not document the default > values for all storage parameters. The only ones that are not covered from what I see are fillfactor and parallel_workers. The settings that cover items in postgresql.conf have defaults shown here: https://www.postgresql.org/docs/current/runtime-config.html As example the default for: vacuum_truncate, toast.vacuum_truncate Per-table value for vacuum_truncate parameter. can be found here: https://www.postgresql.org/docs/current/runtime-config-vacuum.html#GUC-VACUUM-TRUNCATE > > Is this an oversight or intentional? > > Thank you. > > -- Adrian Klaver adrian.klaver@aklaver.com