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 1ocjOw-0001pK-Pb for pgsql-hackers@arkaria.postgresql.org; Mon, 26 Sep 2022 08:23:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ocjOu-00009O-NF for pgsql-hackers@arkaria.postgresql.org; Mon, 26 Sep 2022 08:23:40 +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 1ocjOu-00009F-C2 for pgsql-hackers@lists.postgresql.org; Mon, 26 Sep 2022 08:23:40 +0000 Received: from mail-wr1-x434.google.com ([2a00:1450:4864:20::434]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ocjOo-00068z-Pq for pgsql-hackers@lists.postgresql.org; Mon, 26 Sep 2022 08:23:39 +0000 Received: by mail-wr1-x434.google.com with SMTP id t14so8948352wrx.8 for ; Mon, 26 Sep 2022 01:23:34 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date; bh=GReEUSrcxjHQY/CJq5hzTM5V8Qk6pPnA5TdyHIk/3Jw=; b=TWIN7HJ2edyPdKC4KrrZ32LQsy8WDhYEacZDVe2dIWOV84OX1ezMl2Lj0FWCogGrWH U4JDXXnC8BVTXsrxP+N9wYVdE1DLA0NhgYOsqbLrwAYf4GeohH84rI+caY203IWgERGX UppWM+vsMxo0Gx9fqRuiUop5XxHXkcqqrScxrvT6fyelFeJQmAn7WR2E1167TK1trCoc DLvJ3bESo32IVwk8KKSQlNmd7pOwihCPQCNNG6ywswuCdZsY5P0kChBEagBCkg/QaRlF 9pZbES58Wb196yV0uZD05ZD+ukUJ9KBc2asJ/111aXDH0AMhc0LOclT5kk+D2z+gkEMX ybXw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date; bh=GReEUSrcxjHQY/CJq5hzTM5V8Qk6pPnA5TdyHIk/3Jw=; b=etFw1hRU+HNQfHbMbE+LJt5+eY5Nqw4hoSO8miUcZ38jrXbm/b9VvPIBA81ZSp8S7R Zv1y/c2/FM14bNk4VrhKdtEvMNlXQtom2tUQyWh0Sjsq4Veo6keTZt0+aR4srBgS38B6 VAKZ1KcRlRYFYigDJD0tRjr6YNMoyVlk64lBSJiLpIys9zZh0PpdtQ/XSmaKwnvrGWyb NVY+/Y34kpmT6QIdtdnwwTySpIJbbBc28iXfudW5vexz1O7q8UAgXdTNbNwhABrD5cku o3/w0rZ91oi59sg3K7uGe4tw+ulz6HnkYuYG/Hlf1/MhA92qExZ8DDKpFsvgWq5xEiP2 rLAQ== X-Gm-Message-State: ACrzQf06NQOpqb+5SwgFpYO4L1UVYZM3HbgEP/hL5SlJ4BFYkleotT/9 Atgc0uaMEIuGyAt0UXiNrOs= X-Google-Smtp-Source: AMsMyM427n80ZQ2DEg/jZTBrVIY4f4Zf8+EVG0bg3yB9vs9mXqm4U7PXhSNGzZLyZJ0LuttNBfS7Aw== X-Received: by 2002:a05:6000:1c8:b0:22a:5a6d:c77a with SMTP id t8-20020a05600001c800b0022a5a6dc77amr11834260wrx.242.1664180612618; Mon, 26 Sep 2022 01:23:32 -0700 (PDT) Received: from [192.168.8.246] ([54.239.6.185]) by smtp.gmail.com with ESMTPSA id e6-20020adfdbc6000000b00228dc37ce2asm13397464wrj.57.2022.09.26.01.23.31 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 26 Sep 2022 01:23:32 -0700 (PDT) Message-ID: Date: Mon, 26 Sep 2022 10:23:30 +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 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> From: "Drouvot, Bertrand" In-Reply-To: <20220923204509.uez54vl2rjlz47vh@awork3.anarazel.de> 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/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! > > I left the replication stuff out - it seemed somewhat independent. Yeah. > Probably > will just push that to master, unless somebody thinks it should be in both? Sounds good to me as this is not a bug and that seems unlikely to me that an issue in this area will be introduced later on on 15 without being introduced on master too. Regards, -- Bertrand Drouvot PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com