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 1qWkJx-004EbJ-JD
	for pgsql-admin@arkaria.postgresql.org; Thu, 17 Aug 2023 21:14:21 +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 1qWkJv-004hws-IT
	for pgsql-admin@arkaria.postgresql.org; Thu, 17 Aug 2023 21:14:19 +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 <ronljohnsonjr@gmail.com>)
	id 1qWkJv-004hwi-55
	for pgsql-admin@lists.postgresql.org; Thu, 17 Aug 2023 21:14:19 +0000
Received: from mail-oo1-xc29.google.com ([2607:f8b0:4864:20::c29])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <ronljohnsonjr@gmail.com>)
	id 1qWkJq-000h0Y-7T
	for pgsql-admin@lists.postgresql.org; Thu, 17 Aug 2023 21:14:16 +0000
Received: by mail-oo1-xc29.google.com with SMTP id
 006d021491bc7-5607cdb0959so209787eaf.2
        for <pgsql-admin@lists.postgresql.org>;
 Thu, 17 Aug 2023 14:14:14 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20221208; t=1692306853; x=1692911653;
        h=content-transfer-encoding:in-reply-to:from:references:to
         :content-language:subject:user-agent:mime-version:date:message-id
         :from:to:cc:subject:date:message-id:reply-to;
        bh=LJL1yuKPlFBk1FCD4Yiy7pobmrSEGPf00vgFZ57Ju/I=;
        b=RHQ4F/Bs9iEFNKAtEmcCe9Jq8q3PCubO5y5MYtQN2DO8KXetavGXr8r4Nv2WbL7KIO
         y99n1o3cKkrLUgUYZm9Wiuzjjv1cUNkg6rWwkd3WDUZglzX2QzFAkDTMXwOxBV5N4yJJ
         oqTdvfN/H48w6XJJrzEM4JHMOT+cp328If1sJwypO2BD9oNwFmB5ug6ZctDxk3uMNrbt
         JDkXzNNIQZSfcsVtTvHS6Nupqvxgjur6/nBrO1qU0pKHdsMQo/3fwVYiL+04yBL5+lt9
         qn0p8TXbSV60Upm23z2hLThnVGVFy6bUTsl9x8OaDpa/AcINktyhulZsl84VLmmUOgCR
         JcaA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20221208; t=1692306853; x=1692911653;
        h=content-transfer-encoding:in-reply-to:from:references:to
         :content-language:subject:user-agent:mime-version:date:message-id
         :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to;
        bh=LJL1yuKPlFBk1FCD4Yiy7pobmrSEGPf00vgFZ57Ju/I=;
        b=kA+khWw/nSwqn0Jm6VBlXOp2eUI/qfEP2GF+QSL/WT2XanIOc0EkYmsBU4Wqud6KEd
         W8Z59Ajlp0+uhyinchjuJCzh3zWbCiqBsP1mHLmcqJYJF2nMCcitiqSGXt2EZhH7Efo4
         A/nd8oMWaJh2T6REHlBID9USTw588Nhh8KBI16lur9X4ggklMdIuOX3dRmyRIrw1XFVZ
         RABlh9ooKACQvP99vuDTc9X1zm92jgNnG3GEPVWXIp1L+GyPhtuvpAj1r7x+Ot1iX/UH
         8gwDy0Bbh8gIHlZDq+pkkslIQECXQlF2uUFDH4KDb6XEGvd2r8xFtMuug73+2x9bXRTM
         Nlqg==
X-Gm-Message-State: AOJu0YxyWl/ix5mL6/Ts/iMnjWoo0luLd4m3v5ym/D4vKxO5Rij7sWI5
	mEzHV/8HIDv3sDQ3UznU/AF0Fdtx/rM=
X-Google-Smtp-Source: 
 AGHT+IEuCet1Cwx+xiBHxS5EkEKjCYmug1/PSmF74KA8moHJ/pSrZxGgT65yRSA9XvjBWlUI4ZenIA==
X-Received: by 2002:a05:6358:2925:b0:137:881b:fc73 with SMTP id
 y37-20020a056358292500b00137881bfc73mr658569rwb.2.1692306853099;
        Thu, 17 Aug 2023 14:14:13 -0700 (PDT)
Received: from ?IPV6:2600:1700:bd2c:b810:f4a4:55ad:e8a:41?
 ([2600:1700:bd2c:b810:f4a4:55ad:e8a:41])
        by smtp.googlemail.com with ESMTPSA id
 p204-20020a815bd5000000b00589fb1f296dsm112026ywb.51.2023.08.17.14.14.12
        for <pgsql-admin@lists.postgresql.org>
        (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128);
        Thu, 17 Aug 2023 14:14:12 -0700 (PDT)
Message-ID: <373a8862-40ab-530b-648d-8c7182ff7c38@gmail.com>
Date: Thu, 17 Aug 2023 16:14:12 -0500
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.11.0
Subject: Re: Autovacuum not working peoperly
Content-Language: en-US
To: pgsql-admin@lists.postgresql.org
References: 
 <CAJk5AtbbdNaPpDY3ghKPU4_Cp5BXmn0Y2wnrwRWEYFwfYYEqtA@mail.gmail.com>
From: Ron <ronljohnsonjr@gmail.com>
In-Reply-To: 
 <CAJk5AtbbdNaPpDY3ghKPU4_Cp5BXmn0Y2wnrwRWEYFwfYYEqtA@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
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/373a8862-40ab-530b-648d-8c7182ff7c38%40gmail.com>
Precedence: bulk

On 8/17/23 14:06, Rajesh Kumar wrote:
> These are parameters have reg autovacuum. Autovacuum is not running 
> properly. How to resolve this?
>
> autovacuum=on log_autovacuum_min_duration=0 autovacuum_max_workers=3 
> autovacuum_naptime=1min autovacuum_vacuum_threshold=50 
> autovacuum_analyze_threshold=50 autovacuum_vacuum_cost_limit=-1 
> autovacuum_vacuum_cost_delay=2ms autovacuum_freeze_max_age=200000000 
> autovacuum_vacuum_scale_factor=0.2 autovacuum_analyze_scale_factor=0.1

Please clarify "not working properly".

-- 
Born in Arizona, moved to Babylonia.