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 1oco9r-0000FC-Na for pgsql-hackers@arkaria.postgresql.org; Mon, 26 Sep 2022 13:28:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oco9q-0000SS-C4 for pgsql-hackers@arkaria.postgresql.org; Mon, 26 Sep 2022 13:28:26 +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 1oco9q-0000SJ-1B for pgsql-hackers@lists.postgresql.org; Mon, 26 Sep 2022 13:28:26 +0000 Received: from mail-wm1-x329.google.com ([2a00:1450:4864:20::329]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1oco9j-00083l-8Z for pgsql-hackers@lists.postgresql.org; Mon, 26 Sep 2022 13:28:25 +0000 Received: by mail-wm1-x329.google.com with SMTP id fn7-20020a05600c688700b003b4fb113b86so3753046wmb.0 for ; Mon, 26 Sep 2022 06:28:19 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=content-transfer-encoding:in-reply-to:references:cc:to:from :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date; bh=3yd352x6sX+o8G+I1CTtqjRl1FiPJ9PblX68kSXFjLY=; b=GvtVUFkZtfRUIWoGWVz7bUK/0Np9W4CTBj2EELmhQIx3koLbyhls+taoFC94UaynAv jNuPgXZprkXKUSgGx57X9+nz0PnWZOCfrn8octrgbPSABPDm/BKPNHxeIYTJ+KuTrZlW E2PX4OhPq5BEGWi3xxobLvk84EYiNmfZMjO+RtzEXZzVZKlGGg2GV9P+LQwdN21xLeE7 718o0i6FoiB6SD4Kp0iwnEk2sLrcTfCpl8z78MkHn1UrROEbXpVb4dEnfg5135orXAgR PD4myfclQOqqtUTfzru92xbXFYlOcfxVS56nvZ4YSXv13abW5LJ/JWAXremiURjFozXZ UIPw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=content-transfer-encoding:in-reply-to:references:cc:to:from :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date; bh=3yd352x6sX+o8G+I1CTtqjRl1FiPJ9PblX68kSXFjLY=; b=VUMen458WSn2nC2kj+uJ3PdluFYUp3JRDG0/HEIou6evhRIlH3OJfiiYLOvwWXdIjx e7bNmaakH1cE/ciBlC1ZS80gBlrTeGDNv+bhmL8P6sGNA2dmRfzaEO464rthlMT3mIMr ZInYbWC7jlgSlTnsxW9OWisX2C2Oi/KTQIVwPembKUr95tsWkikwW8+UFghDOsSszFR1 ke9lpJBHMBOu5kCb9+ittDU4ZorwDoaWiwcpDKLqDEWHs50sWJYbyz1q4FHsrrjkazKZ XqTMgozoA1M49w1iRj3YW5nHhHOcTpX6kYimB71dahT7CYUNNQiX1/d5/nOh3eidx98H xucw== X-Gm-Message-State: ACrzQf0THPil71+m/R4w/3GYVlOm2VUXveioHswS2doyDSnxbf1cDEkX IAvOSS95oH1+U28KShOXRwc= X-Google-Smtp-Source: AMsMyM4+E8iUpbmFKLGq1XUOekCL1XsEJ/01zQY11mYzFQgNZ4n/c/eP7ffO1zwBWFiCRPH0yxZRVQ== X-Received: by 2002:a05:600c:1694:b0:3b4:6205:1f95 with SMTP id k20-20020a05600c169400b003b462051f95mr23001507wmn.151.1664198898309; Mon, 26 Sep 2022 06:28:18 -0700 (PDT) Received: from [192.168.8.246] ([54.239.6.185]) by smtp.gmail.com with ESMTPSA id f10-20020a05600c154a00b003b339438733sm11884278wmg.19.2022.09.26.06.28.17 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 26 Sep 2022 06:28:17 -0700 (PDT) Message-ID: <82877387-6737-3f82-118a-591d39bc2f5e@gmail.com> Date: Mon, 26 Sep 2022 15:28:16 +0200 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0) Gecko/20100101 Thunderbird/102.3.0 Subject: Re: pg_stat_have_stats() returns true for dropped indexes (or for index creation transaction rolled back) Content-Language: en-US From: "Drouvot, Bertrand" To: Andres Freund Cc: Kyotaro Horiguchi , pgsql-hackers@lists.postgresql.org References: <51bbf286-2b4a-8998-bd12-eaae4b765d99@amazon.com> <20220822173654.y4h2smhc4kpkvoeg@awork3.anarazel.de> <61a95a06-cf88-cd15-0412-172717943e18@amazon.com> <20220825.114727.330127256246111733.horikyota.ntt@gmail.com> <20220831192657.jqhphpud2mxbzbom@awork3.anarazel.de> <3cd209a4-e2a1-0ae6-91a3-c945eb7db248@amazon.com> <20220923204509.uez54vl2rjlz47vh@awork3.anarazel.de> 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 Hi, On 9/26/22 10:23 AM, Drouvot, Bertrand wrote: > Hi, > > On 9/23/22 10:45 PM, Andres Freund wrote: > >> >> >> >> Hi, >> >> On 2022-09-01 08:40:54 +0200, Drouvot, Bertrand wrote: >>> Thanks for the suggestion, I'm coming up with this proposal in v4 >>> attached: >> >> I pushed the bugfix / related test portion to 15, master. Thanks! > > Thanks! > Forgot to say that with that being fixed, I'll come back with a patch proposal for the tables/indexes stats split (discovered the issue fixed in this current thread while working on the split patch.) Regards, -- Bertrand Drouvot PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com