pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Drouvot, Bertrand <bertranddrouvot.pg@gmail.com>
To: Andres Freund <andres@anarazel.de>
Cc: Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Cc: pgsql-hackers@lists.postgresql.org
Subject: Re: pg_stat_have_stats() returns true for dropped indexes (or for index creation transaction rolled back)
Date: Mon, 26 Sep 2022 15:28:16 +0200
Message-ID: <82877387-6737-3f82-118a-591d39bc2f5e@gmail.com> (raw)
In-Reply-To: <d8811220-9ab4-21d8-2bf6-d815e7a74498@gmail.com>
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>
	<be4c74ba-e229-126b-6dff-0c879c70c547@amazon.com>
	<20220831192657.jqhphpud2mxbzbom@awork3.anarazel.de>
	<3cd209a4-e2a1-0ae6-91a3-c945eb7db248@amazon.com>
	<20220923204509.uez54vl2rjlz47vh@awork3.anarazel.de>
	<d8811220-9ab4-21d8-2bf6-d815e7a74498@gmail.com>

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





view thread (12+ messages)

Message-ID: <82877387-6737-3f82-118a-591d39bc2f5e@gmail.com>
Permalink:  ../82877387-6737-3f82-118a-591d39bc2f5e@gmail.com/
Also on:    postgresql.org/message-id/82877387-6737-3f82-118a-591d39bc2f5e@gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-hackers@postgresql.org
  Cc: bertranddrouvot.pg@gmail.com, andres@anarazel.de, horikyota.ntt@gmail.com
  Subject: Re: pg_stat_have_stats() returns true for dropped indexes (or for index creation transaction rolled back)
  In-Reply-To: <82877387-6737-3f82-118a-591d39bc2f5e@gmail.com>
  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> <be4c74ba-e229-126b-6dff-0c879c70c547@amazon.com> <20220831192657.jqhphpud2mxbzbom@awork3.anarazel.de> <3cd209a4-e2a1-0ae6-91a3-c945eb7db248@amazon.com> <20220923204509.uez54vl2rjlz47vh@awork3.anarazel.de> <d8811220-9ab4-21d8-2bf6-d815e7a74498@gmail.com> <82877387-6737-3f82-118a-591d39bc2f5e@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox