Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kxKXC-0007vs-0d for pgsql-admin@arkaria.postgresql.org; Thu, 07 Jan 2021 01:56:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kxKXA-0007Pu-JQ for pgsql-admin@arkaria.postgresql.org; Thu, 07 Jan 2021 01:56:16 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kxKXA-0007Pm-Bk for pgsql-admin@lists.postgresql.org; Thu, 07 Jan 2021 01:56:16 +0000 Received: from mail-wr1-x431.google.com ([2a00:1450:4864:20::431]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kxKX7-0001Sg-RU for pgsql-admin@lists.postgresql.org; Thu, 07 Jan 2021 01:56:15 +0000 Received: by mail-wr1-x431.google.com with SMTP id t16so4125184wra.3 for ; Wed, 06 Jan 2021 17:56:13 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20150623.gappssmtp.com; s=20150623; h=message-id:subject:from:to:date:in-reply-to:references:user-agent :mime-version:content-transfer-encoding; bh=Ue0CRuRpHL4+5nnrs2ICOgR8cJCJLn+Ub/Sh7BbaaW4=; b=TTSYTASqtL28ptoMBpkJdoACZvEWtkovmzsfoz1XEanGqI8eleDcRREvFLbZYlDZH+ SOcKrGMbHSC4eEBMI2cUr7Lg4hOcvRynKGl15fbo3lQsex7LPebvP1zXqldZ/eYtG+ae 0VwJ+alPcwNAzn6y22kmSec60DmbTPhm0xm1BAVuAuSKM5GbJjUtlGT1zVt6L88dTIB1 vmoGf0A3mEHRrHXw7dPEIrI4ZPkqyMB+fTV/EXS99/xG+Y8Kwwtjth9bEdG0LfWSQBhk 9pR/dKxNLJcz/yA6kGn8B1Pewbt8O4u1Cl2+DUHjsMQf60pyckHAWIJJZheooWWVONQk JHqA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:message-id:subject:from:to:date:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=Ue0CRuRpHL4+5nnrs2ICOgR8cJCJLn+Ub/Sh7BbaaW4=; b=eMDx65nElT4HyltvBD0baTSVTml9F/jSt+wkyFHRm26JGAVl3XfffAjVwfqj3sufNI GdsXrUk/ErFxRQqmypkiOtq+KvV9t5dg0q1AtURthwY8M+9JX9PeaJqQK0WpF+BCw2VI D7UJdvJto2qsMrIDTWSL0uv4a0T6KuIYV7i4mxBAtPqZkAB8kNpc7F5ugxV9TMQ48qqY VN05l97wSKkLQBjTAP0KMlFCKylQhMvdLDKi7Ei0OW/vcVkf+3PDPInApJ2XGrmQc7lH hKa1CVmkGixC+8aWWbztcycZrYiSH2DgtgHkgOhUi3PdCZLWJxeEqmwBK3FrpTFG465C rfbA== X-Gm-Message-State: AOAM532hwlEk9sIFZPhBqzr2dGpKLfvep1ykOfN9OlhVAJ6FOtjTQlSu eiqUfgIC7J9kNolwTL1WvpzEvQ== X-Google-Smtp-Source: ABdhPJwLlfpI1r1Zn7AgQ85E04FR8dGNTv5uC8a9k2wXsPXXX4GUyAb8wlgb1mE+lNBeoyLrQ500GA== X-Received: by 2002:a5d:6884:: with SMTP id h4mr6637941wru.174.1609984572880; Wed, 06 Jan 2021 17:56:12 -0800 (PST) Received: from localhost.localdomain (178-190-179-204.adsl.highway.telekom.at. [178.190.179.204]) by smtp.gmail.com with ESMTPSA id d191sm5174605wmd.24.2021.01.06.17.56.12 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 06 Jan 2021 17:56:12 -0800 (PST) Message-ID: <79ceeb349617ed8a65b19c01530461521510009d.camel@cybertec.at> Subject: Re: quick q re migration, index, stats From: Laurenz Albe To: Scott Ribe , Pgsql-admin Date: Thu, 07 Jan 2021 02:56:11 +0100 In-Reply-To: <8DB33DAF-479F-487F-924A-3360676D8103@elevated-dev.com> References: <8DB33DAF-479F-487F-924A-3360676D8103@elevated-dev.com> Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.36.5 (3.36.5-2.fc32) MIME-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Wed, 2021-01-06 at 09:41 -0700, Scott Ribe wrote: > As part of migration to PG 13, I'll be updating Linux as well, thus complete reindex required. > > So just confirming that I still need to manually run vacuumdb --all --analyze-in-stages? > In other words, reindexing doesn't capture stats as it processes the rows? You are right, you still need to calculate statistics. By the way, you only need to rebuild those indexes that contain string data types, unless you want to make use of the new index compression feature in v13. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com