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 1qxSXB-0010lN-Nb for pgsql-admin@arkaria.postgresql.org; Mon, 30 Oct 2023 13:42:25 +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 1qxSXA-00EEIK-D1 for pgsql-admin@arkaria.postgresql.org; Mon, 30 Oct 2023 13:42:24 +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 1qxSXA-00EEIC-27 for pgsql-admin@lists.postgresql.org; Mon, 30 Oct 2023 13:42:24 +0000 Received: from mail-yw1-x1132.google.com ([2607:f8b0:4864:20::1132]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qxSX7-0033Z9-Oq for pgsql-admin@lists.postgresql.org; Mon, 30 Oct 2023 13:42:22 +0000 Received: by mail-yw1-x1132.google.com with SMTP id 00721157ae682-5afb93d310fso29432987b3.3 for ; Mon, 30 Oct 2023 06:42:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1698673341; x=1699278141; darn=lists.postgresql.org; 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=rOdjVAMgKxuyg+mdz01LY+bGCi0mEjj52Z1SRPzVK2A=; b=XjmGcMAVASEKm4apU2BfePKAwy2egYtTV9cq48xT1sDfLVIdW+9YmvuQNvLlUDGjVk 2rLw5UF/MeM9M2NaxspQWq8fAplhZmQ71o39WlL2XoO40sdViK9N1UlJvK8DlYwgSnDd 13eEgdknW5ASwS71I+EjaflSewOmHxvoFGDtJJyiWcUoX7bW2IPAVHpBdN2quA4Qgxds DL4sWeRglYUMe6oFgrJMcxRuVP9ZBXPg6TzVdHVHhy1QzJQuP7f8xDqMph0tLyg0LUdv USwVZm0k04lzxonl7qD+MWojT3tiUMl1jz9Ea0MwKeP9y1UnT2w5ZNse6pYegVzLcpRI g3ZA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1698673341; x=1699278141; 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=rOdjVAMgKxuyg+mdz01LY+bGCi0mEjj52Z1SRPzVK2A=; b=gYhnOChjcURZQCZ+fMJwbeXzmKZTTJQGJ3dBpqTjwozV82GWKgH5ToLa3SPVlsUyly MvAL1sEFdPODotYDZs3NiVsjejW+UJ1cXr4VwI14DIEQ3CWDGY4BAdiRZyNUEL33J748 2P7vZpIDYpt/Nm9Ej1FSKf0lHrEyidF3qRldj4jfjQu55t3w/5xeQP+RB10rpwD1RqKf dJJe7Rm73GmnSQHif4VIErJW+Td1I32JEhhQOxlQNnEWA+6t8hY/gs4AiLafQhQA0nHe xQBZ9pRm5/XeCkjYcfYpX+yTz1NVpUkIG4c4opMOt5W7FIqB3wNmvdB6yoHV9MBSEmoF aB2g== X-Gm-Message-State: AOJu0YygAxWIcHecOqkq+ZWAtCHl9IKFxW53qZxLc62sQZzz1ngwL5vF V4aMAMqVWhs2L6oCnHK0hVx0aDhzAek= X-Google-Smtp-Source: AGHT+IH0swQZxTkXUO9vko7xeTAKCTOisgKD0LzYRuUmRLbZqSCio8OB1MD6N2GI21+8zW8OWciC2Q== X-Received: by 2002:a0d:d5d7:0:b0:5ad:cd52:d6f0 with SMTP id x206-20020a0dd5d7000000b005adcd52d6f0mr12433839ywd.45.1698673340583; Mon, 30 Oct 2023 06:42:20 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:b5c1:9971:5e81:a8fe? ([2600:1700:bd2c:b810:b5c1:9971:5e81:a8fe]) by smtp.googlemail.com with ESMTPSA id u204-20020a8184d5000000b005afd25725absm4163973ywf.97.2023.10.30.06.42.20 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 30 Oct 2023 06:42:20 -0700 (PDT) Message-ID: <58efda50-df4f-4322-b746-4a6326aff8f4@gmail.com> Date: Mon, 30 Oct 2023 08:42:19 -0500 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: AUTOVACUUM Content-Language: en-US To: pgsql-admin@lists.postgresql.org References: From: Ron In-Reply-To: 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 10/30/23 06:20, Siraj G wrote: > Hello - > > What are the dictionary objects/scripts we have to check if AUTOVACUUM > parameters are set correctly and need any tuning? On Linux: psql -c "SHOW ALL;" | grep "^ autovacuu" Then exit $PGDATA/postgresql.conf -- Born in Arizona, moved to Babylonia.