Trigger autovacuum on tuple insertion

Edit

ID 2093

Title Trigger autovacuum on tuple insertion

Topic Performance

Created 2019-04-09 04:26:21

Last modified 2020-03-28 07:50:47 (4 years, 7 months ago)

Latest email 2020-04-02 23:44:34 (4 years, 7 months ago)

Status

2020-03: Committed

2020-01: Moved to next CF

2019-11: Moved to next CF

2019-09: Moved to next CF

2019-07: Moved to next CF

Target version

Authors Laurenz Albe (laurenz)

Reviewers David Rowley (davidrowley), Laurenz Albe (laurenz), Justin Pryzby (justinpryzby)Become reviewer

Committer David Rowley (davidrowley)

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

Emails

Berserk Autovacuum (let's save next Mandrill): First at 2019-03-27 20:54:57 by Darafei "Komяpa" Praliaskouski <me at komzpa.net>
Latest at 2020-04-02 23:44:34 by Tom Lane <tgl at sss.pgh.pa.us>
Latest attachment (different-partition_aggregate-stability-fix.patch) at 2020-04-02 15:46:36 from Tom Lane <tgl at sss.pgh.pa.us>
    Attachment (different-partition_aggregate-stability-fix.patch) at 2020-04-02 15:46:36 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (temp_telemetry_checks_for_unstable_tests.patch) at 2020-03-29 02:29:51 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (insert_autovac_v12.patch) at 2020-03-26 21:18:40 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (0001-Autovacuum-tables-that-have-received-only-inserts.v10.patch) at 2020-03-23 13:27:29 from Laurenz Albe <laurenz.albe at cybertec.at> (Patch: Yes)
    Attachment (vacuum.c) at 2020-03-20 02:05:03 from David Rowley <dgrowleyml at gmail.com> (Patch: No)
    Attachment (0001-Autovacuum-tables-that-have-received-only-inserts.v9.patch) at 2020-03-19 19:47:40 from Laurenz Albe <laurenz.albe at cybertec.at> (Patch: Yes)
    Attachment (v8_fixes.diff.txt) at 2020-03-19 08:39:37 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (0001-Autovacuum-tables-that-have-received-only-inserts.v8.patch) at 2020-03-17 21:55:32 from Laurenz Albe <laurenz.albe at cybertec.at> (Patch: Yes)
    Attachment (0001-Autovacuum-tables-that-have-received-only-inserts.v7.patch) at 2020-03-17 19:42:07 from Laurenz Albe <laurenz.albe at cybertec.at> (Patch: Yes)
    Attachment (0001-Autovacuum-tables-that-have-received-only-inserts.v6.patch) at 2020-03-17 00:14:02 from Laurenz Albe <laurenz.albe at cybertec.at> (Patch: Yes)
    Attachment (0001-Autovacuum-tables-that-have-received-only-inserts.v5.patch) at 2020-03-10 19:07:03 from Laurenz Albe <laurenz.albe at cybertec.at> (Patch: Yes)
    Attachment (0001-Autovacuum-tables-that-have-received-only-inserts.v4.patch) at 2020-03-06 14:45:50 from Laurenz Albe <laurenz.albe at cybertec.at> (Patch: Yes)
    Attachment (0001-Autovacuum-tables-that-have-received-only-inserts.v3.patch) at 2020-03-05 14:27:31 from Laurenz Albe <laurenz.albe at cybertec.at> (Patch: Yes)
    Attachment (0001-Autovacuum-tables-that-have-received-only-inserts.v2.patch) at 2020-03-04 15:15:47 from Laurenz Albe <laurenz.albe at cybertec.at> (Patch: Yes)
    Attachment (0001-Autovacuum-tables-that-have-received-only-inserts.patch) at 2020-03-03 15:28:57 from Laurenz Albe <laurenz.albe at cybertec.at> (Patch: Yes)
    Attachment (autovacuum_berserk_v1.patch) at 2019-03-27 20:54:57 from Darafei "Komяpa" Praliaskouski <me at komzpa.net> (Patch: Yes)

History

When	Who	What
2020-04-08 03:25:10	Justin Pryzby (justinpryzby)	Added justinpryzby as reviewer
2020-03-28 07:50:47	David Rowley (davidrowley)	Closed in commitfest 2020-03 with status: Committed
2020-03-19 13:46:01	Justin Pryzby (justinpryzby)	New status: Ready for Committer
2020-03-15 10:10:48	Justin Pryzby (justinpryzby)	Changed authors to Laurenz Albe (laurenz)
2020-03-10 02:27:30	David Rowley (davidrowley)	New status: Waiting on Author
2020-03-10 02:27:22	David Rowley (davidrowley)	Added davidrowley as committer
2020-03-09 09:12:33	Laurenz Albe (laurenz)	New status: Ready for Committer
2020-03-04 22:44:35	David Rowley (davidrowley)	Added davidrowley as reviewer
2020-03-04 22:44:31	David Rowley (davidrowley)	New status: Needs review
2020-03-04 14:03:58	Laurenz Albe (laurenz)	New status: Waiting on Author
2020-03-04 14:01:52	Laurenz Albe (laurenz)	Changed reviewers to Laurenz Albe (laurenz)
2020-03-04 14:01:52	Laurenz Albe (laurenz)	Changed authors to Darafei Praliaskouski (komzpa)
2020-03-03 15:33:13	Laurenz Albe (laurenz)	Changed reviewers to
2020-03-03 15:33:13	Laurenz Albe (laurenz)	Changed authors to Laurenz Albe (laurenz), Darafei Praliaskouski (komzpa)
2020-03-03 15:32:28	Laurenz Albe (laurenz)	Added laurenz as reviewer
2020-02-01 12:50:19	Tomas Vondra (fuzzycz)	Closed in commitfest 2020-01 with status: Moved to next CF
2019-11-30 02:15:09	Michael Paquier (michael-kun)	Closed in commitfest 2019-11 with status: Moved to next CF
2019-09-30 18:57:00	Álvaro Herrera (alvherre)	Closed in commitfest 2019-09 with status: Moved to next CF
2019-08-02 00:00:42	Thomas Munro (macdice)	Closed in commitfest 2019-07 with status: Moved to next CF
2019-04-09 04:26:37	Darafei Praliaskouski (komzpa)	Changed authors to Darafei Praliaskouski (komzpa)
2019-04-09 04:26:21	Darafei Praliaskouski (komzpa)	Attached mail thread CAC8Q8t+j36G_bLF=+0iMo6jGNWnLnWb1tujXuJr-+x8ZCCTqoQ@mail.gmail.com
2019-04-09 04:26:21	Darafei Praliaskouski (komzpa)	Created patch record

Edit