Simplify some RI checks to reduce SPI overhead

Edit
Comment/Review
Change Status
ID 2948
Title Simplify some RI checks to reduce SPI overhead
Topic Performance
Created 2021-01-19 02:47:18
Last modified 2022-04-09 16:59:11 (2 years, 7 months ago)
Latest email 2022-04-07 01:05:36 (2 years, 7 months ago)
Status
2022-03: Returned with feedback
2022-01: Moved to next CF
2021-11: Moved to next CF
2021-09: Moved to next CF
2021-07: Moved to next CF
2021-03: Moved to next CF
Target version
Authors Amit Langote (amitlan)
Reviewers Tom Lane (tgl), Corey Huinker (coreyh)Become reviewer
Committer Álvaro Herrera (alvherre)
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/2948
git checkout commitfest/cf/2948
Emails
simplifying foreign key/RI checks
First at 2021-01-18 12:39:48 by Amit Langote <amitlangote09 at gmail.com>
Latest at 2022-04-07 01:05:36 by Amit Langote <amitlangote09 at gmail.com>
Latest attachment (v15-0001-Add-isolation-tests-for-snapshot-behavior-in-ri_.patch) at 2022-04-07 01:05:36 from Amit Langote <amitlangote09 at gmail.com>
    Attachment (v15-0001-Add-isolation-tests-for-snapshot-behavior-in-ri_.patch) at 2022-04-07 01:05:36 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v15-0001-Add-isolation-tests-for-snapshot-behavior-in-ri_.patch) at 2022-03-22 04:01:06 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v14-0001-Add-isolation-tests-for-snapshot-behavior-in-ri_.patch) at 2022-03-14 08:33:26 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v13-0002-Avoid-using-SPI-for-some-RI-checks.patch) at 2022-01-18 06:30:52 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v12-0001-Add-isolation-tests-for-snapshot-behavior-in-ri_.patch) at 2021-12-20 13:17:16 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v11-0001-Add-isolation-tests-for-snapshot-behavior-in-ri_.patch) at 2021-12-20 06:20:28 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v10-0001-Add-isolation-tests-for-snapshot-behavior-in-ri_.patch) at 2021-11-19 13:56:59 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Export-get_partition_for_tuple.patch) at 2021-07-06 01:48:38 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Export-get_partition_for_tuple.patch) at 2021-04-04 08:19:48 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Export-get_partition_for_tuple.patch) at 2021-04-02 12:46:18 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v7-0002-Avoid-using-SPI-for-some-RI-checks.patch) at 2021-03-20 13:21:54 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v6-0002-Avoid-using-SPI-for-some-RI-checks.patch) at 2021-01-27 13:02:35 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v5-0002-Avoid-using-SPI-for-some-RI-checks.patch) at 2021-01-24 11:51:39 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Export-get_partition_for_tuple.patch) at 2021-01-23 07:10:24 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v3-0002-Avoid-using-SPI-for-some-RI-checks.patch) at 2021-01-19 07:44:56 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Export-get_partition_for_tuple.patch) at 2021-01-19 02:45:29 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Export-get_partition_for_tuple.patch) at 2021-01-18 12:39:48 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
History
When Who What
2022-04-09 16:59:11 Greg Stark (stark) Closed in commitfest 2022-03 with status: Returned with feedback
2022-04-07 12:17:19 Álvaro Herrera (alvherre) Added alvherre as committer
2022-02-02 16:30:00 Julien Rouhaud (rjuju) Closed in commitfest 2022-01 with status: Moved to next CF
2021-12-02 11:30:38 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2021-11 with status: Moved to next CF
2021-12-01 10:37:11 Peter Eisentraut (petere) Removed petere from reviewers
2021-11-19 14:48:16 Amit Langote (amitlan) New status: Needs review
2021-11-12 21:22:49 Tom Lane (tgl) New status: Waiting on Author
2021-11-11 23:27:04 Tom Lane (tgl) Added tgl as reviewer
2021-10-05 15:53:07 Jaime Casanova (jcasanov) Closed in commitfest 2021-09 with status: Moved to next CF
2021-08-31 15:36:45 Peter Eisentraut (petere) Added petere as reviewer
2021-08-30 04:36:33 Corey Huinker (coreyh) New status: Ready for Committer
2021-08-24 02:40:24 Amit Langote (amitlan) Changed name to Simplify some RI checks to reduce SPI overhead
2021-08-03 02:27:14 Masahiko Sawada (masahikosawada) Closed in commitfest 2021-07 with status: Moved to next CF
2021-04-08 15:43:09 David Steele (dsteele) Closed in commitfest 2021-03 with status: Moved to next CF
2021-03-20 13:23:06 Amit Langote (amitlan) New status: Needs review
2021-03-03 20:18:39 Tom Lane (tgl) New status: Waiting on Author
2021-03-01 23:48:18 Corey Huinker (coreyh) New status: Ready for Committer
2021-01-20 03:57:36 Amit Langote (amitlan) Changed name to simplify some RI checks to reduce SPI overhead
2021-01-19 05:14:16 Corey Huinker (coreyh) Added coreyh as reviewer
2021-01-19 02:47:31 Amit Langote (amitlan) Changed authors to Amit Langote (amitlan)
2021-01-19 02:47:18 Amit Langote (amitlan) Attached mail thread CA+HiwqGkfJfYdeq5vHPh6eqPKjSbfpDDY+j-kXYFePQedtSLeg@mail.gmail.com
2021-01-19 02:47:18 Amit Langote (amitlan) Created patch record
Edit
Comment/Review
Change Status