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.94.2) (envelope-from ) id 1u7FR4-00DWQd-Ht for pgsql-general@arkaria.postgresql.org; Tue, 22 Apr 2025 15:21:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1u7FR1-00FK7y-7M for pgsql-general@arkaria.postgresql.org; Tue, 22 Apr 2025 15:21:20 +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.94.2) (envelope-from ) id 1u7FQz-00FK7q-Vf for pgsql-general@lists.postgresql.org; Tue, 22 Apr 2025 15:21:19 +0000 Received: from fhigh-a1-smtp.messagingengine.com ([103.168.172.152]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1u7FQu-001QdW-26 for pgsql-general@postgresql.org; Tue, 22 Apr 2025 15:21:18 +0000 Received: from phl-compute-01.internal (phl-compute-01.phl.internal [10.202.2.41]) by mailfhigh.phl.internal (Postfix) with ESMTP id F272F11402A2; Tue, 22 Apr 2025 11:21:10 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-01.internal (MEProxy); Tue, 22 Apr 2025 11:21:10 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc: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=fm1; t=1745335270; x=1745421670; bh=NjQ0Ac4efZU6ARnjSW4oQJey+xAVU+ffeKqY9gAcAvc=; b= MtSgJKcb5x9tdLOlnJjOoEwKNOix4RCP/QbXx0bBxQSWFoAjQV0ex3KEZj3qsiGD vROi6yBIcBVbvLwiuUKWd2X+Y1tUP6I3hWfOl647OZgDAV9egwViivjjX7nrk68Z +M3j44IhrF94b6z7WjLFfa0WETSB71dabo7za9ra+Z/qHfVqguhSPhEqnxPRCV68 JGmZhU/T4qBI6PoOszWeJJXCkt4D/FBmqdJmdRoemBcsUTdSUBCOELOPx+z8WGDv S9LwcrGGDTzJtJY5RJpP0vcA9HG9stFXYTJ66MFEXAqylAPe9eht9a55GkYHwVrn uUdO5b80Qyk0bA8dN7v14A== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc: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=fm2; t=1745335270; x= 1745421670; bh=NjQ0Ac4efZU6ARnjSW4oQJey+xAVU+ffeKqY9gAcAvc=; b=r GnT2DE+IoTBp4HIzCQbpjjeGRqFwNB+mnyC5/pLezva1w/W4Zwhgi0+8UZmGLa7j IgCXgqTxQZcplB0AIumzb0tNg+Lps0vku9hQfETfoELWzvHLKiSG7VMjCPdMJx7u GSOn+ToyMo80UBUQ2yGkpCJgcIstw80Co8AmTdsBTWoWyep4tPZMf88vW6Yiqz+1 O1bzOFxi9hlwSDmqu1UUD6hELM+pSiP1+E1paq9G6ZLYCG08BV3u71Y5ut+qNZi7 pwgHPTjEC7+/HlBrK5bRs3HdXiVRULTOtOJFRs+AfEqej60Nb8U/DX6CJH8O6lZZ TkKEcFOSmLFuwKxLZ1/5A== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgddvgeegtdejucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggv pdfurfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucenucfjughrpefkff ggfgfuvfevfhfhjggtgfesthejredttddvjeenucfhrhhomheptegurhhirghnucfmlhgr vhgvrhcuoegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhmqeenucggtf frrghtthgvrhhnpeeuudefjeejgffgtddtgeehgfekueevkeekieettedtkeffheeivdet hfevffegueenucffohhmrghinhepphhoshhtghhrvghsqhhlrdhorhhgnecuvehluhhsth gvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprggurhhirghnrdhklhgr vhgvrhesrghklhgrvhgvrhdrtghomhdpnhgspghrtghpthhtohepvddpmhhouggvpehsmh htphhouhhtpdhrtghpthhtoheprghnthhonhdrthigthesghhmrghilhdrtghomhdprhgt phhtthhopehpghhsqhhlqdhgvghnvghrrghlsehpohhsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 22 Apr 2025 11:21:10 -0400 (EDT) Message-ID: <7858785e-d2d3-43ff-93d4-8517f7820e50@aklaver.com> Date: Tue, 22 Apr 2025 08:21:09 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Cannot turn track_counts on To: Anton Shepelev Cc: pgsql-general@postgresql.org References: <20250416122749.2b2d25cafcd76aa7d633ed07@gmail.com> <1900177.1744815217@sss.pgh.pa.us> <20250417170534.b2e919e950b77c4d4dbd5483@gmail.com> <1a99f488-9d24-41d1-a1a5-17ea4ce87899@aklaver.com> <20250418002307.a029379d2c0f781ca7726f91@gmail.com> <20250421194644.cdd5064d94d58edd62e54dc1@gmail.com> <91d7fc8f-58c5-4932-9f23-32f2341776b4@aklaver.com> <20250422113130.7519e029c3c29c07b08b2b66@gmail.com> Content-Language: en-US From: Adrian Klaver In-Reply-To: <20250422113130.7519e029c3c29c07b08b2b66@gmail.com> 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 4/22/25 01:31, Anton Shepelev wrote: > Adrian Klaver: > >> There is something different about your setup, as here on >> Ubuntu(which uses the Debian packaging) I see: >> [...] > > Yes. It is on on your side, and pgsql shows NULL values as > NULL. Can the latter be due to a differnce in Postgres > versions, for mine is 11.21 (as I have reported before)? No that is because I have my ~/.psqlrc set up with: \pset null 'NULL' From here: https://www.postgresql.org/docs/current/app-psql.html See the: Meta-Commands \pset section as well as Files psqlrc and ~/.psqlrc > user@xx:/opt/sva$ psql -V > psql (PostgreSQL) 11.21 (Debian 1:11.21-astra.se6+ci1) > > but `track_counts' is stuck off only on one. > > A complete reinstall with purging of all configuration data > comes to mind, but it is a last-resort measure, as the > system is a production one, and actively used. > Given that the Debian Postgres packaging allows you to install multiple clusters of a given version I would create a new 11.21 cluster as a test and see what track_counts is set to. That would help determine whether the setting is coming from the initial install. You could then add the other components to the cluster one by one and see if and where the track_counts setting changes. -- Adrian Klaver adrian.klaver@aklaver.com