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 1l9XWl-0000Tp-C1 for pgsql-admin@arkaria.postgresql.org; Tue, 09 Feb 2021 18:14:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l9XWk-0000Vh-7w for pgsql-admin@arkaria.postgresql.org; Tue, 09 Feb 2021 18:14:18 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l9XWj-0000VW-Ve for pgsql-admin@lists.postgresql.org; Tue, 09 Feb 2021 18:14:18 +0000 Received: from mout.gmx.net ([212.227.17.20]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l9XWf-0008AL-9m for pgsql-admin@lists.postgresql.org; Tue, 09 Feb 2021 18:14:16 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=badeba3b8450; t=1612894450; bh=a4BrfQlpxvhcDrOyAQek1Ju+IZ2YugrvjI6XiGc6eYY=; h=X-UI-Sender-Class:Subject:To:References:From:Date:In-Reply-To; b=OUssnULx2yamEUXvKth7NxqqwETbr0KO3fAJVfMIy+0qIRpSuIM1h6JveNMf/oyRM zAtYNDPDBrQChewKntJH9sCArsb/NptGVtotVX7P1oXxQTZzn9DCuEjUvmV5JijU0+ gtA+8GKy52H/XT0vnQ9A4m82v61y7Rgw3engRYl8= X-UI-Sender-Class: 01bb95c1-4bf8-414a-932a-4f6e2808ef9c Received: from [192.168.178.20] ([83.171.167.177]) by mail.gmx.net (mrgmx104 [212.227.17.168]) with ESMTPSA (Nemesis) id 1MRTRN-1lWpfT079B-00NNpO for ; Tue, 09 Feb 2021 19:14:10 +0100 Subject: Re: Postgres 12 -> 13 any need to re-index? To: pgsql-admin@lists.postgresql.org References: From: Thomas Kellerer Message-ID: <3ee9404b-fe47-c215-c373-df7a98b67226@gmx.net> Date: Tue, 9 Feb 2021 19:14:09 +0100 User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.21) Gecko/20090302 Thunderbird/2.0.0.21 Mnenhy/0.7.5.666 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: de-DE Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:/N0uVezYOvnPQJ17wv5jEw7lHdU/zWYu4S9UFfcIi8iGuGyufAr OGmLXyZF1NxXTi2fAqFiU824EWhnVARE+fWlWewkur6IrP3K6llzHULoP/NkrNwK4+wUCPH yPG9tQT9WRHaLd4mhTmPaatrTDUR/w4Y3anQaMHwUCglV3tcF1gHe/l3GSlo9GnBzab2kQ5 Vsc7DlWSg/GBx2vD0JnSw== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:DOQgJ9xi3p0=:KpAYQTMro3jaWYrswk4HX8 Op83wADOJltA1dCNE5Hw3Dtm/AA3eErIvElwRAWUkS8QRDP06ZcVtfdpGhiEfDyNcSEUr71S2 JcYgcHSWAx1etWxQc8I3MoyLE2Vuf/wj48k7CPdApvcWHHxna85TEh5DzTTMphdyWJ8ZJUWcp liJ/qVNOTRm/FBi56xkcTpEtDVTH9hfr/V3U5SFnt2oQAn0tWTHwjaJaGKrvbBEFeWIWwpdR1 M6X04ynQ0jAW4tVRbAUBdZTzSCNmgxwvscPTMrrMf0SsESASj5ldY+MqyKRbUl/bNkWp7atDw SqgAL6oFgclH/VcJ9idmeo9cDo6oBrdF6KUtZe1eK9JA1zI67El5CAfPix+L/yWJ0//U2XbnP PcEjNaw7MMjocUmpPhD2SVs6ijzSIe6AcQcrC2oBIHa5abAzCZTN1slEul0VoTwwXhgcv+xk7 0fzQYI4G1xQV5inD/77chXiiCE1/KKwWbtjA6/SceH57aaiO+BPbYgsVL6bFOOA7tDo+mGqA4 NRloy8zScVvcSSgfafv1BjuPyKIf5datfbfQURksdSPcBavCWfB4EQUzjW7ROcDzgkWyqnjSl yxyZdQCAqSwn0kLBoP9F/+6G/mSFknFVsJ9SIzcdq7153yic+GEIpIWGag3wSZ/vz4JIHJXXp iXmTydp9rflN4TgOFUagHjpRQo3nnDzHDwIBvbW18sv+ZGu5lDAxiwDFCKZ1nBWidKGDECVIr 8H280NzqE9YWPNYLsYnpXKEZsz6yFFww1GC3zRakjElSJ4U0YKwE4345I+AB0P1SSHAWu8t8n s2Pc11UXT0S2f82cLlqjd6zmMDP5LNvBnps4+1B9atV9mW7X2z6dU7WVUW8u8VgVjii5skpU7 MyhoavMJPBN2Dt7DxNAA== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Wells Oliver schrieb am 09.02.2021 um 19:00: > Hey guys, I just upgraded a DB from 12 to 13. In testing this seemed > to go well, but it seems like most of my queries are not using the > indexes after the upgrade, so everything is quite so. > > Is there a general need to REINDEX after upgrading to 13, or might > there be another issue? The configuration parameters are the same as > they were persisted via pg_upgradecluster. If you want to profit from the new de-duplication in indexes, you will nee= d to reindex.