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 1vEXfN-00D2C6-RP for pgsql-general@arkaria.postgresql.org; Thu, 30 Oct 2025 18:46:33 +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 1vEXfM-00A2uy-LO for pgsql-general@arkaria.postgresql.org; Thu, 30 Oct 2025 18:46:31 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vEXfM-00A2uq-8u for pgsql-general@lists.postgresql.org; Thu, 30 Oct 2025 18:46:31 +0000 Received: from mail-oi1-x230.google.com ([2607:f8b0:4864:20::230]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vEXfJ-004bme-0k for pgsql-general@lists.postgresql.org; Thu, 30 Oct 2025 18:46:30 +0000 Received: by mail-oi1-x230.google.com with SMTP id 5614622812f47-44d9d7aacc5so431556b6e.0 for ; Thu, 30 Oct 2025 11:46:29 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1761849988; x=1762454788; darn=lists.postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=QpPKmRqu2ok4jElKR5c1BjlrG6K9CMGesdP8S1TwkA4=; b=OhFUuykJRTO8Fvcr/wB63Jeb/xGIY4lGGRDh55wc9DI5D6ahuHKz3OOP0qGTYH0zl0 McQ6RJ/NzOEGArplBCxNqx9V8NjLg6hq3AC+I0tKzKpXB5bklqq2fKH2Bp15hOJnbiPH yKaUJ+gMdra7KJSpHdm3XNTG2wlB4cXuheXPH7LscpPiD0y2zRfaM80ZeKparQSxSLIZ m7NebzNV6r0sOrfVWlyBJRXgaVSE2k+ZBOmF/X1WGPv6b7bCRndkEsh2l5XIPGQSP6r0 uawCndvHRGyM+gKwxP6w0JokZSrC/aIGUMR4YOxpWO9UznPGvRDp+fbAaokvEs2AlsD6 Dsnw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1761849988; x=1762454788; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=QpPKmRqu2ok4jElKR5c1BjlrG6K9CMGesdP8S1TwkA4=; b=ESI9gyhCc5S0xUSYX7vn1zbWt/3KeJN9GMpdOI/fjk9J6SGQzH87RN55I6MyzIXnjD bbIBRlAw5++TfufA/WdXu6PX4peu1WavyYh47GyHtcX1nl5QcXdvogduHyxLREl3AxZR a+0ggSXiHZQrdI2jZxvJV6awCwhhygPpV8031iy2oQ2tU36tdC59Icu2ANQeiHC0eDmK McQ6KPnKlq8nhn0lrzltbTXx09Xd2CYGhCn7MzYHbVFd5T2SQqcYpPhE1jA1pcapXskJ TU9dJIPnbq7qUYR+eWNY/Zv9Ne+Oq/7CI5o41NG57l0DT1o0Cb2IPQtNILB7mOblKSxb kTIA== X-Gm-Message-State: AOJu0Yw0kVN0fxuZP9d9CebqKxBdPxcS/5J7ZxzKp6UUefPyeRhmqFLK 7dBZ/iq9qwMTYrJR+dU7VyUSwjusxOeTxN+kmPMBq6v0lgwnK/EAqIokjovs6i4mf0D2SBVfbKt L4Ec0pRiDJY8KpcnKWweFfwJeFeHk4/aHmX1X X-Gm-Gg: ASbGnctLuWjRdKsdEdn68dvSdgRRlpzUkyWessEKvcnM/KCxuer0oF33+eVnxr6a/80 gzscEBE1hG8ZVikBHH7f5xz5IYUO4SXWsc28kUUu9u0tDj46oeg4WDOx2upi6iN/wX0f/OuWbbr 0x4WV8EGA5xgYnzBPr2SD+Ii7lW/dxHvIRBnNQXf7OManoJnRdlDJyBgpkbZ4ogE9V0rSZdCvZr kE4WkEife3cIjydk3cKLYeFHRPnDyINHawMrc8AzxxIYQoPFtXasGlSiLqSmQ== X-Google-Smtp-Source: AGHT+IHSRFDGppjg7q+mUDutXWbaVaP2sQa1FeckHyv6YpgGOiYhdSbXxvCoeTNwpFNmar9+hfF5ATRWuYaac8ZDnbo= X-Received: by 2002:a05:6808:4f12:b0:443:a287:4f08 with SMTP id 5614622812f47-44f95e3a511mr360615b6e.20.1761849988181; Thu, 30 Oct 2025 11:46:28 -0700 (PDT) MIME-Version: 1.0 References: <26qs98r6-0q81-non7-3n17-0r14o9851pp9@tzk.arg> In-Reply-To: From: Ron Johnson Date: Thu, 30 Oct 2025 14:46:17 -0400 X-Gm-Features: AWmQ_bnYrCl9lpfdr27ra3hLzlz_fE0L7l_GhuQ3o6H5lgTJ9IWEJlAH0G8Dxpc Message-ID: Subject: Re: Why isn't my table auto-analyzed/vacuumed? To: "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000b172b1064264aab2" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000b172b1064264aab2 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thu, Oct 30, 2025 at 2:41=E2=80=AFPM Dimitrios Apostolou = wrote: > 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%'= ; > > name | setting > > ---------------------------------------+--------- > > autovacuum_analyze_scale_factor | 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 > https://www.postgresql.org/docs/17/runtime-config-autovacuum.html#GUC-AUTOV= ACUUM-ANALYZE-SCALE-FACTOR "Specifies a fraction of the table size to add to autovacuum_analyze_threshold when deciding whether to trigger an ANALYZE. The default is 0.1 (10% of table size)." --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --000000000000b172b1064264aab2 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Thu, Oct 30, 2025 at 2:41=E2=80=AFPM D= imitrios Apostolou <jimis@gmx.net&g= t; wrote:
On Thursday 2025-10-30 18:00, Ron Jo= hnson wrote:

>On Thu, Oct 30, 2025 at 11:55=E2=80=AFAM Dimitrios Apostolou <jimis@gmx.net> wrote:
>=C2=A0 =C2=A0 =C2=A0 > SELECT name,setting FROM pg_settings WHERE na= me ILIKE '%factor%' ;
>=C2=A0 =C2=A0 =C2=A0 =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 =C2=A0 =C2=A0 ---------------------------------------+---------<= br> >=C2=A0 =C2=A0 =C2=A0 =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_anal= yze_scale_factor' \gx

-[ RECORD 1 ]
min_val | 0
max_val | 100

"Specifies a fraction of the table size to add to=C2=A0autovacuum_analyze_threshold=C2=A0when deciding whether to trigger an=C2=A0ANALYZE. The default is 0.1 (10% of table size)."
<= div>
--
Death to <Reda= cted>, and butter sauce.
Don't boil me, I'm still alive.
=
<Redacted> lobster!
--000000000000b172b1064264aab2--