Refactoring speculative insertion with unique indexes a little

Edit

ID 403

Title Refactoring speculative insertion with unique indexes a little

Topic Refactoring

Created 2015-10-24 08:24:46

Last modified 2016-09-20 07:57:59 (8 years, 2 months ago)

Latest email 2016-09-27 14:00:40 (8 years, 2 months ago)

Status

2016-09: Rejected

2016-03: Moved to next CF

2016-01: Moved to next CF

2015-11: Moved to next CF

Target version

Authors Peter Geoghegan (pgeoghegan)

Reviewers Heikki Linnakangas (heikki)Become reviewer

Committer

Links CFbot results (CirrusCI) CFbot GitHub

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/403
git checkout commitfest/cf/403

Emails

Refactoring speculative insertion with unique indexes a little

First at 2015-06-10 23:19:27 by Peter Geoghegan <pg at heroku.com>
Latest at 2016-09-27 14:00:40 by Peter Geoghegan <pg at heroku.com>
Latest attachment (0001-Refactor-speculative-insertion-into-unique-indexes.patch) at 2016-03-16 23:43:06 from Peter Geoghegan <pg at heroku.com>

Attachment (0001-Refactor-speculative-insertion-into-unique-indexes.patch) at 2016-03-16 23:43:06 from Peter Geoghegan <pg at heroku.com> (Patch: Yes)
Attachment (0001-Refactor-speculative-insertion-with-unique-indexes.patch) at 2015-06-10 23:19:27 from Peter Geoghegan <pg at heroku.com> (Patch: Yes)

Annotations

When	Who	Mail	Annotation
2016-03-16 23:58:49	Peter Geoghegan (pgeoghegan)	From Peter Geoghegan <pg@heroku.com> at 2016-03-16 23:43:06	New revision. Worked through much of Heikki's much earlier feedback.

UPSERT strange behavior

First at 2016-08-25 14:12:38 by Ivan Frolkov <ifrol2001 at mail.ru>
Latest at 2016-08-25 20:04:12 by Peter Geoghegan <pg at heroku.com>

Annotations

When	Who	Mail	Annotation
2016-08-25 21:57:03	Peter Geoghegan (pgeoghegan)	From Peter Geoghegan <pg@heroku.com> at 2016-08-25 19:59:41	Patch may have important role in edge-cases with more-or-less equivalent indexes that cannot be inferred as equivalent (by the index inference machinery)

History

When	Who	What
2016-09-20 07:57:59	Heikki Linnakangas (heikki)	Closed in commitfest 2016-09 with status: Rejected
2016-09-19 19:22:31	Heikki Linnakangas (heikki)	Added heikki as reviewer
2016-08-25 21:57:03	Peter Geoghegan (pgeoghegan)	Added annotation "Patch may have important role in edge-cases with more-or-less equivalent indexes that cannot be inferred as equivalent (by the index inference machinery)" to CAM3SWZTFTbK_Y=7uWJaXYLHnYQ99pV4KFpmjTKbNJR5_+QThzA@mail.gmail.com
2016-08-25 21:55:56	Peter Geoghegan (pgeoghegan)	Attached mail thread 1472134358.649524557@f146.i.mail.ru
2016-04-08 06:45:38	Robert Haas (rhaas)	Closed in commitfest 2016-03 with status: Moved to next CF
2016-03-16 23:58:55	Peter Geoghegan (pgeoghegan)	New status: Needs review
2016-03-16 23:58:49	Peter Geoghegan (pgeoghegan)	Added annotation "New revision. Worked through much of Heikki's much earlier feedback." to CAM3SWZTo6KRG0o7QmgXrtd_rc0PqU_KhSm27Rm=QmPMLd6QOug@mail.gmail.com
2016-03-02 10:42:29	Anastasia Lubennikova (lubennikovaav)	New status: Waiting on Author
2016-02-08 20:45:35	Álvaro Herrera (alvherre)	Closed in commitfest 2016-01 with status: Moved to next CF
2015-12-19 23:26:17	Michael Paquier (michael-kun)	Closed in commitfest 2015-11 with status: Moved to next CF
2015-11-11 06:05:57	Michael Paquier (michael-kun)	Changed topic to Refactoring
2015-10-24 08:24:55	Peter Geoghegan (pgeoghegan)	Changed authors to Peter Geoghegan (pgeoghegan)
2015-10-24 08:24:46	Peter Geoghegan (pgeoghegan)	Attached mail thread CAM3SWZTpWo-guh7bZ3xXU9W=QuUHmhLGE2_GO7anGhCOaYg=7A@mail.gmail.com
2015-10-24 08:24:46	Peter Geoghegan (pgeoghegan)	Created patch record

Edit