pg_stat_have_stats() returns true for dropped indexes (or for index creation transaction rolled back)

Title

Topic

Bug Fixes

Created

2022-08-22 16:50:21

Last modified

2022-09-26 08:29:07 (2 years, 1 month ago)

Latest email

2022-09-26 13:28:16 (2 years, 1 month ago)

Status

2022-09: Committed

Target version

Authors

Bertrand Drouvot (bdrouvot)

Reviewers

Yogesh Sharma (sharmay)Become reviewer

Committer

Andres Freund (andresfreund)

Links

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/3832
git checkout commitfest/cf/3832

Emails

pg_stat_have_stats() returns true for dropped indexes (or for index creation transaction rolled back): First at 2022-08-22 16:39:07 by "Drouvot, Bertrand" <bdrouvot at amazon.com>
Latest at 2022-09-26 13:28:16 by "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com>
Latest attachment (v4-0001-pgstat_drop_relation-for-indexes.patch) at 2022-09-01 06:40:54 from "Drouvot, Bertrand" <bdrouvot at amazon.com>
    Attachment (v4-0001-pgstat_drop_relation-for-indexes.patch) at 2022-09-01 06:40:54 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v3-0001-pgstat_drop_relation-for-indexes.patch) at 2022-08-25 09:44:34 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v1-0002-pgstat_drop_relation-for-indexes.patch) at 2022-08-23 07:58:03 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v1-0001-pgstat_drop_relation-for-indexes.patch) at 2022-08-22 16:39:07 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)

History

When	Who	What
2022-09-26 08:29:07	Bertrand Drouvot (bertranddrouvot.pg)	Closed in commitfest 2022-09 with status: Committed
2022-09-26 08:29:07	Bertrand Drouvot (bertranddrouvot.pg)	Changed committer to andresfreund
2022-09-01 11:28:51	Yogesh Sharma (sharmay)	Added sharmay as reviewer
2022-08-22 16:50:53	Bertrand Drouvot (bdrouvot)	Changed authors to Bertrand Drouvot (bdrouvot)
2022-08-22 16:50:53	Bertrand Drouvot (bdrouvot)	Changed targetversion to 16
2022-08-22 16:50:21	Bertrand Drouvot (bdrouvot)	Attached mail thread 51bbf286-2b4a-8998-bd12-eaae4b765d99@amazon.com
2022-08-22 16:50:21	Bertrand Drouvot (bdrouvot)	Created patch record