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 <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1rtrG1-000NHv-AI
	for pgsql-admin@arkaria.postgresql.org; Mon, 08 Apr 2024 15:50:05 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1rtrG0-008zDt-HO
	for pgsql-admin@arkaria.postgresql.org; Mon, 08 Apr 2024 15:50:04 +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 <scott_ribe@elevated-dev.com>)
	id 1rtrG0-008zDl-1k
	for pgsql-admin@lists.postgresql.org; Mon, 08 Apr 2024 15:50:04 +0000
Received: from mailout.easymail.ca ([64.68.200.34])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <scott_ribe@elevated-dev.com>)
	id 1rtrFx-001qgv-Ce
	for pgsql-admin@lists.postgresql.org; Mon, 08 Apr 2024 15:50:02 +0000
Received: from localhost (localhost [127.0.0.1])
	by mailout.easymail.ca (Postfix) with ESMTP id 0474D6E573;
	Mon,  8 Apr 2024 15:50:00 +0000 (UTC)
DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=elevated-dev.com;
	s=easymail; t=1712591400;
	bh=rGLjpsxPfDo7D2wqZt9naf4yIglqjTb0MaccV0HNmfw=;
	h=Subject:From:In-Reply-To:Date:Cc:References:To:From;
	b=JUUn/B/ri2ZBy7SLwFLXqXnG/v3xOh1MEbesSCs0lmWfIqolIMwm1zQEx3/Cklu6g
	 R7ZH19jTDcTsgzAYuzqPqMeDQS/cEqV0NFHK1I0jfvAQKUZXmucHKSj3oE6yqbV08K
	 DtAC7frRfHpK5maFVlHnrUqi23ZYxgonFUwm9F2xfr4bQ9dIIYVbQ1ZydHH3/GgGs3
	 7b3tymvzPi1M9a/iwPt4F2bg9jNwSHH+DrEhlrZ/BedTXwv8muB/jcDSS59/+/9gDR
	 UlQaplqsw8wmBrm5iMiVMFqqqLbjbXzKvun++RSvsBca3RRaHJ7eSTvgCPztsmGVTW
	 4nBPMXxlgp9hw==
X-Virus-Scanned: Debian amavisd-new at emo07-pco.easydns.vpn
Received: from mailout.easymail.ca ([127.0.0.1])
	by localhost (emo07-pco.easydns.vpn [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id Q52AAsZh5rQs; Mon,  8 Apr 2024 15:49:59 +0000 (UTC)
Received: from smtpclient.apple (unknown [165.140.184.195])
	(using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits))
	(No client certificate requested)
	by mailout.easymail.ca (Postfix) with ESMTPSA id 837546E52C;
	Mon,  8 Apr 2024 15:49:59 +0000 (UTC)
DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=elevated-dev.com;
	s=easymail; t=1712591399;
	bh=rGLjpsxPfDo7D2wqZt9naf4yIglqjTb0MaccV0HNmfw=;
	h=Subject:From:In-Reply-To:Date:Cc:References:To:From;
	b=2mDhkLe3IGR7qP+mR6kRr3O0I2L3+7aai6G1M881bChcg+4Yav8WleEFy9JVo77xW
	 ll2T6rTZDMKGHV7HFb35p3wn7ZfqMT8eHQl5tPsmnWMWq+TSvHCmmhzxPPLEDInTN2
	 /K/lqM+aEhMmXNThGDHUNU3TM6JYOWvf6tc3Roemn2yoCrsTfe2b09CG5cVztYqs9W
	 V2HKB2SQl0KnkLBEcLfVXc7O5WRXA9k2KljVdHNWE4pooreraaSUB/fU9Jq3VqYc9z
	 NUpD6aWwK2mZVAHokxCs6pYp2pii0HMl5BFJ+/hYFMupOjjsykCv6YV/KUI01zQfds
	 tMkUSvvpDW8pg==
Content-Type: text/plain;
	charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.500.171.1.1\))
Subject: Re: Autovacuum------Doubts
From: Scott Ribe <scott_ribe@elevated-dev.com>
In-Reply-To: 
 <CACd4L3uzo0nmo3SBujTj_qzqWSOxyFx9svwY4FmeqP0DHjxwmw@mail.gmail.com>
Date: Mon, 8 Apr 2024 09:49:48 -0600
Cc: Laurenz Albe <laurenz.albe@cybertec.at>,
 pgsql-admin@lists.postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <A41DA2B9-966F-47AD-963C-A1469010DFB3@elevated-dev.com>
References: 
 <CACd4L3t3a7LHgJDysnKY6DQ1cBC6aeVhV=p3cVF3gOAtfUGvDA@mail.gmail.com>
 <70109b120e8f26fa29c1d0003a729639a5dec196.camel@cybertec.at>
 <CACd4L3vi0iRzSesQUDcMLGBJPpVOkLVoXBx=KGqzmpSGHUUudA@mail.gmail.com>
 <42e852495e19c1de2e734a666ae30d9b3e37abe1.camel@cybertec.at>
 <CACd4L3uzo0nmo3SBujTj_qzqWSOxyFx9svwY4FmeqP0DHjxwmw@mail.gmail.com>
To: jaya kumar <kumardba27@gmail.com>
X-Mailer: Apple Mail (2.3774.500.171.1.1)
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/A41DA2B9-966F-47AD-963C-A1469010DFB3%40elevated-dev.com>
Precedence: bulk


> On Apr 8, 2024, at 9:23=E2=80=AFAM, jaya kumar <kumardba27@gmail.com> =
wrote:
>=20
> autovacuum_vacuum_threshold + autovacuum_vacuum_scale_factor * number =
of table rows

20 + 0.1 * 100 =3D 30, not 2010=