Trigger autovacuum on tuple insertion

Edit

Title

Topic

Performance

Created

2019-04-09 04:26:21

Last modified

2020-03-28 07:50:47 (4 years ago)

Latest email

2020-04-02 23:44:34 (4 years 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

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