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 1vEXal-00D1AS-Ka for pgsql-general@arkaria.postgresql.org; Thu, 30 Oct 2025 18:41:47 +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 1vEXak-009zvk-99 for pgsql-general@arkaria.postgresql.org; Thu, 30 Oct 2025 18:41:45 +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 1vEXaj-009zvc-TQ for pgsql-general@lists.postgresql.org; Thu, 30 Oct 2025 18:41:44 +0000 Received: from mout.gmx.net ([212.227.17.22]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vEXag-0057Dd-29 for pgsql-general@lists.postgresql.org; Thu, 30 Oct 2025 18:41:44 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1761849701; x=1762454501; i=jimis@gmx.net; bh=0FoAUMTErNKVOsJwLpws8v1i+PxC6TLaKdrvZirfyFc=; h=X-UI-Sender-Class:Date:From:To:cc:Subject:In-Reply-To:Message-ID: References:MIME-Version:Content-Type:cc:content-transfer-encoding: content-type:date:from:message-id:mime-version:reply-to:subject: to; b=QcXa1Tf7GvYui5s+9gmiY0gAqeRO1FoAh3e9WgFQAdKttgj4rjbhaJ2upu3uuOpz ePzd4morgkuSuxNglbQmtyk56QdrsaxmxvqAz025/mQpLTBVt+EjC+5ZdXRK1QAms o1lxnrWIIa3a4u2OKi1jNU0NyDUXNyx96C8QE8sl1YzETKqgF8kCSejoqW8bq8m7C HOGnbQwaeInX4S7BHMt5va5I/ANoS26P/BxY/q7cgn1n7G6fg6IXvBfdQwluNFa9i i3eO9tVBc1zhaibxyNLzWJTTB/57KHsf5Nf1FqScBBnM5+ri5Xj33YzdU0VtbRHf/ oyRSZRGarsHJ0TD5FA== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [10.9.70.66] ([185.55.106.54]) by mail.gmx.net (mrgmx104 [212.227.17.168]) with ESMTPSA (Nemesis) id 1MWAOQ-1vl14g3pmc-00RZfU; Thu, 30 Oct 2025 19:41:41 +0100 Date: Thu, 30 Oct 2025 19:41:39 +0100 (CET) From: Dimitrios Apostolou To: Ron Johnson cc: pgsql-general@lists.postgresql.org Subject: Re: Why isn't my table auto-analyzed/vacuumed? In-Reply-To: Message-ID: References: <26qs98r6-0q81-non7-3n17-0r14o9851pp9@tzk.arg> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="0-2088043133-1761849700=:929621" X-Provags-ID: V03:K1:tj8p/B/2JYJ6sJMYr0Z3fyDR3T4mvaKMy0iSEvhi6ymSRRprx5Y tuGWQ/e2BNHUOreJI1IF5pyzAyxi/kdiYPpnrTCcVkezjuVgAMupjTXm96V3IPulsv6NI+e 4I4It/ZVJgfo2j14p00/QVsZe1FkGxExl/7aTFXp+TfUPh9ZwoYo+ihw0Oqdf6u0b232mJe Uq6xNk2S97ktPdr9mo+QA== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:w9PLbg/u864=;bQPZ1zRiGNFVk3xpQTLhqhb3xTc t+LH6k0OjqIi8IH7Sry9bMEx+EFmjxV7IKQzWzpEla7Jxi7vpfb4VFe1V6G+N79h3wkGzSHzj I1/HzHrAJCuwQaH/cp2xlRsiZzz8ZZUYotClZE16770X4XlnfpBHRXAdfS9J1e6L39FeOa+4d hynVdJQia+MJi14j/M7W1eoFZbDwgSM9wjbj7KYhSqDqDgPv+zxC+tGS+dvCHZgX3RSAddGXP p486OeQ8hsjZqo20mPV8dEfmugdBT8qWJ6cNObFlZ2z06mFzXJ4lbRs7Uhc3Asx7Zar+ijE8K x11jilp2aCnQWuk8cH8RP2XRcUwdNFgBK0Qz2Cu3pFJUrBYSpcu/C3DiMW/8nIsjVL0Ov0tF1 tySVMO6C1a/JBV4MJZ63BuV6CHbj4eYaw+qSSPi0EAER4wHz4BPax2F8L8cjrfc+qUntaMTp0 j8Rfvy5Sq2jdWdaMcyS90345jP3N/yhkYKReG1RaVlQgxrpnzlGmz455LoW3YAqB/+pqV3TtP dpi/MsboXg07t9fK3e89308RMXwySppu9jjKp1E9EEl5g2QynmE9xNhscJwfr3tpO4DYVJl/L LI2x5T3utMyLPBwa7RU6ZjGfFqUn1HLeZSXHEHNqdd9ZWqP2i4MH1BflYqrqpLxzW03p+QqSe lPGQFfLXUU1pJZKFrrhm2rqSzEdVncoHy2OfUG5pA1eaYmyDm2IWogg4zkGUm05xi8ISCytGU mPSpbNP8GsRSqZ94aGihwUKurFjaPNMKAOOiduGPTCjeRsEUR1aMevVaXLv7f4GMwMBfsl+6Q cvut6lRaxlHz4bJVdPbhI6f4IYQ429DUw8Jk11rpivI53a6KWs6zLPmmrU3x+L47l9aIPrhKQ vxHOj4XLA6ydQL6CvWs3Dh7aT8fDpEq8t8H4ZtPn1wJyQX3s/ijZrZ3dm6t99gGk/EkRriC8/ PqfRNku62tDtMMWlicif8EkFBf9hPy231xN1atLfY/btsBGBBqF2Pzk1zDuDqDNyk3OXOB4h9 qXmwJRUG2L5M0dAB5JMUx+wvCct6mYnGf/buZhbNY0x3yz8t2cZaFjRWcLM/73mQeIrpcO6Ly N/3CkoxjSt41Fjg11cP8tpXdlI8jVynnfsPaAT4rsA3yuZhvNMxNK25pTv02SgdJh/5gnQEHC i3w3dfcpAVrsadoA5P1ghCPv1LkbjBHkURMCdDPQTeJG4HRcvaPo6qQkpe10JzNc8j6YR35ru QslHVkTxC9dlEmBXQYIY2sP5BQ+Wq25Llsg+OWOAUdtMn/WyppMqQbUi5wNskwlE5+Ou7wAiL pSFdC/d9AdP+0qa+BT4yG/wK/S7euDSIjJ2oGlmlo+0FjXPLX0iUcAzIdIVoPK55dlSSO1z66 ktsIjBx7gCQYbsEzxh5XJ7/33+4ZI/SaoATLP3L/q4Ic2gBwa2G65kL2Zqs1xxuyoLENKbK7N Px2gnxZcO5E3UnGtN59ySDf9S+I/rzidTQyf7ScRsUx/2/8Mmk1Z2ffUiS+smDveXGnZts6Dx orRANp9K2QE/xc1mMU6QaXn6McuOXK5VKs4nrZYz5XW9WvNWSH8rOo7zR2rHDW9tJP3yg5dox 3P3kIMVvsyEyDV8Im86YY8tmNhznzzSD/sItL4KJF9PBm27SZoRbq/bhznStJ9CMRuLyO9mkB O4PEcYfRsZ+UedjPAWFxcWp9A+g5Obbd/v5iSCKY3icjxsyFu2fxgiF1gIjIMo+J/fyZhUxzW 8CACX4ur3Fh2xlIPIkvp3i2xkyNYzwdsxJ77Z9d9xYvfwgf1KAge75tnt+r6E3Yub+tsZP9+l EJKvxwEX31a0plDU684LkjhzwaAmiCJ82arc9so3ge33ihomnInsxvVQmP0WxmvSeRGr92dkK OcGP/PnIl+D9iSk60j+AuNk5XLb3O1qdLYSjAOVG2iSD5tG/Ge297FkyyUMHrUDtuwwY5Hnpq 3bn5CXL1y93G+xGHKYfezrIKzdJEAbqkXQs3ZER3f5+oAA1rwjlPcahwIQUYou170Kl3dhk1i lK/Bj4Db8nXdnORDy6BTmdO0dyNrI1gM4606N0oe0p4itu6cpHKBh1IDoKJ730doSy86wiIwU FsiWLkFgln2M55VdNQjc9z9lRhmDjIXARL03KrifFxdSHxbCvXySKonJLKjgMvK/ChHdweuRO GudPV8a4RDJoLEf8GBBEg1Ux+3LX5MvWmtt4hA9VATC114bDNzuJ2rKLF31XwYmU0m3vTjxYz cIVxrSTFzlUepIHpabMHmFrwFq/r35tAVwrSHLYDNKlN8S3Sb5FY79h1MAZ1e/a+hXd017woK Rb7uGIxDxhdPK/k3VaDd40dUg11K/dE9HCuFlWYY3b+crgbu2zfKjOFcLi6N5RfNSnqVHnBWm 9zyKZy4mx1yGIc5i6t94apSAUFngrUCmV0PdbXMoVMgk6pW9eIkjii26zJG6P2mIpUdKhqJEs h6iyF+Jfg0Ld/C3IQr86b+lhd4ZnUIYVwvfl1UQcktXALYzl3RP8LtpeedZNAr4McZjof+bBd YGFrmYVDJPQ9GVP6prISTfpjEUHE4GRaZFUyCUZF1lkHS9pMM0v3vOrXCUY+VdubzoUgYpIFZ AAJn9zZLtzLcnCSvRb3eAAy8hDZKxnPenWl06s8iEhNHtQQunqJa4ytg8sBxSPLsgNyMqNM8+ 2+TGx+05Q/qiFTnsKnjzEHFYXP55Xr3q5JocvKFG84sW+pRyEtrHpO47bloWvRNouRoZ5zZY9 M5RLO2BSyClCw7UC1H6r+Y4XfORTFP7PQXnQ0047uFl3T2Ibq4N4FIqSmxnn8JDi7qqofirqI 6prqFBEQy0e5XsSRpNtXTn4eepDuY8UewuEwOuHrRZM8MVa6HcyZnr1XxYItHvmceJHzsV485 tKWi65b1NWejxnxqLzgW4wNvOb95mVypbBzTbNkquQi/y32/8cmTqWhEe5N4a6s9+hHPQungY xPgNnRZ9EtXeODzoiAGNC0p+V8YwyLP6e09+hcVLOk3IgX3+Sz0n2W9tDk8nf0NCHsdbOOrXQ YJRy0Dwtj2VnQEYmYjHK+d2dbIURvrXOsEAf8l9jqVnvc81eyZPmWn8G5u3ifQ57UPFFlW3zZ tjFpAWKzFp/Ml13TSJZCVsYeBqlVZGGZy1dAaZP9aw6jAZjrnOnGtScj2IYP40iZCvvEAm2CC kudp2LDh5V/ZJVeiyVDoG7xUGEVAfP94XNhAMBH+fU/cbJyhnqzS4pGBt1iOpgJdCFIVieOnL Mywf5sjjKgUfiVL1I+g04n3gJfBn5POp7rylcozT3ULF/savgW2ft4rUEkTCiTvbD9qPRs7es 5TM4zRDemmpGa4T0jPD5PMsVWXMZuuP8cGtDLA9B8WlgSXkifsuDy7SKJ+a1O4m1as2BpAX32 BJwaXUvd371c757snW/ZLRv5BrSVUUDJ+VTcGp/rRmwH6z+m/9j1TLE0tq369Q1ykEaUeqjLI 393CnY6Ns2CUmNxbHdfoO309cl+XPoWwBO/mRwHZ1T4JEp62uWbtshztlBf3SLdwN/u25COGB 243KA+n4g7PRp4miImow39xsIJyvTo5Voyfvl6ZdWg1TV52U58tomlPuIfkwWqzNnowcEKp/S zyB3ONtzEGj718JaDiNt4JQ2F6olKs1iLFfAT2lnilmJU4xe6zqKuCLlcXrS6Jqfj9UlEVPAA 9vCDAuzUIo4ApdT4Ek1LyWaXACldDa0MPNKjytycfXKqY4pDtY2N3qogkqhJsZIqIsxRGnL2V n/2wu74HeOCdOZz0ZDVM7qKTqgSl8IrNhKvbt/oqQE3wCEc67Ma3a4536rIWYyGjYTu7VNNA2 GlX6YLWaYcTrpviEi2MH92BqXXZO4uUkNm+eVqacadA+QfhKl4EjwKyV5BbeLrjkCQUDuvNTP jwaF29VgPe2mpPsIXWdMrOdJHvlC0i1jDML3X3foe6iTqHtdw6rzdlrEID99OnSsmMUzRgxIb /XAawPaMYKRvGblNn64eEamwebnIciGClCJWgcRMjcWpK62nvSbcyGBSvPB2+m9TfT0CAFCXW dvhswH7c4GSOFSnlY3R9hLCbWbdeaU88K6FsogmHc+2cOJMXWsDpoQI9BLIwBtEqdf6DfwbAp /WmDucMChwLIA7gWaycsZ7+HjymPmzlEl7yPc13lJ5aGYpipmtzqXBAzPRcXnkF3hDu/2AXkf OdEHPzNt/KWaNr9R0c32tOl0VSsQIdRTtroKrAb3/Dc12wqH1BzFK5HsE2zGF4ff06s8FI0YA eXxi5Byl/TgGiwwKM73aAmFkH/hEnuNXxuiorCJ7NXnQKXQtx2naVc6z8WXbPZ/IIsnNkysld xUfnK+CzLtiDlUeR5XzXLXH7CcoqEhxi+97TEOMSDQw940F/V/V3vSbponGGtWhCynH6FLM9p +D303mnP6SK9a7gi5V7F1eTtXiJ0iVMpXpu2EJuzmhJqlGdMKvEncjtbFTz5NG127/BOyX1HP 4rIeIima+pkenS9AizrwIWo1on66VmVmmulqJF2wKza/quI2WK0fz5mjIsfNoXRLSSLMwPz5h kNPG5j+7k7yOQzvb1ZXV03kczda7I68DJblwzsS2joHnHuwUWeZARpspUtlvND/Ls8Ge2E57A bHrHiQdRJ+Hv+lMFqYTfStVAEqa4fcoIQIMKsxtn8zd8FOS5ZZB6RIc/xRcdSCkmIpuBwTZAl lqrQbxpY6tdawhGaEBx51OJ0E7VZx/t4Kr6lxN8sJhGoVSCmqh8Oz8M1J2obFRBgy7LIO/R16 c5yMIVDuCDRgZemNwHOtHrQ9yzBK8GHlnf91qYpphTvChVqcw/iESNc3Grpl7gSjW0ro0PT+N q4RlU6yS3SjJVgVhTQVIhvYTNEbZRLNwtwh0WJHtPRHR8L2mMMePwtbHq5jDwYHrjJuBhtvgQ HRTsd1rk0NXSiFPHaVG5riNEWAeByiMY3lUrO4kFf46TCw/RYkhgeGTGgjYTOKKR+BGl46iU1 4rljZbNf1ThOYebPcqXvbducumSZJjZNTJbMK3GqhZrE2+ub2pAwZv1Fl54v2ebGnkzAeJ0/9 +h6qQ== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This message is in MIME format. The first part should be readable text, while the remaining parts are likely unreadable without MIME-aware tools. --0-2088043133-1761849700=:929621 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: quoted-printable On Thursday 2025-10-30 18:00, Ron Johnson wrote: >On Thu, Oct 30, 2025 at 11:55=E2=80=AFAM Dimitrios Apostolou wrote: > > SELECT name,setting FROM pg_settings WHERE name ILIKE '%factor%' = ; > =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 name= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | setting > ---------------------------------------+--------- > =C2=A0 autovacuum_analyze_scale_factor=C2=A0 =C2=A0 =C2=A0 =C2=A0| = 0.1 > > >0.1 means 10%. Thank you Ron! I was quite sure 0.1 meant 1/1000 because of this: SELECT min_val,max_val FROM pg_settings WHERE name =3D 'autovacuum_analyze= _scale_factor' \gx -[ RECORD 1 ] min_val | 0 max_val | 100 I will adjust the values accordingly and check back. Cheers! Dimitris --0-2088043133-1761849700=:929621--