Trigger more frequent autovacuums for insert-heavy tables

5320

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v12, Patch count: 1, First patch: +37−16, All patches: +37−16

Topic

Performance

Tags

Created

2024-10-22 19:15:42

Last modified

2025-03-03 19:46:18 (3 months ago)

Latest email

2025-03-03 19:47:33 (3 months ago)

Status

2025-03 (2025-03-01 - 2025-04-08): Committed

2025-01 (2025-01-01 - 2025-01-31): Moved to different CF

2024-11 (2024-11-01 - 2024-11-30): Moved to different CF

Target version

Authors

Melanie Plageman (melanieplageman)

Reviewers

Nathan Bossart (bossartn)Become reviewer

Committer

Melanie Plageman (melanieplageman)

Links

Emails

Trigger more frequent autovacuums of heavy insert tables: First at 2024-10-22 19:12:53 by Melanie Plageman <melanieplageman at gmail.com>
Latest at 2025-03-03 19:47:33 by Melanie Plageman <melanieplageman at gmail.com>
Latest attachment (v12-0001-Trigger-more-frequent-autovacuums-with-relallfro.patch) at 2025-03-03 17:18:37 from Melanie Plageman <melanieplageman at gmail.com>
    Attachment (v12-0001-Trigger-more-frequent-autovacuums-with-relallfro.patch) at 2025-03-03 17:18:37 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v11-0002-Trigger-more-frequent-autovacuums-with-relallfro.patch) at 2025-02-26 21:48:20 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v10-0002-Trigger-more-frequent-autovacuums-with-relallfro.patch) at 2025-02-25 22:19:30 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Add-relallfrozen-to-pg_class.patch) at 2025-02-25 15:21:01 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Add-relallfrozen-to-pg_class.patch) at 2025-02-24 23:35:18 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v7-0002-Trigger-more-frequent-autovacuums-with-relallfroz.patch) at 2025-02-21 00:35:32 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v6-0002-Trigger-more-frequent-autovacuums-with-relallfroz.patch) at 2025-02-06 15:42:43 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (autovacuums.png) at 2025-02-05 22:08:09 from Melanie Plageman <melanieplageman at gmail.com> (Patch: No)
    Attachment (v5-0002-Trigger-more-frequent-autovacuums-with-relallfroz.patch) at 2025-01-16 22:50:14 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Add-relallfrozen-to-pg_class.patch) at 2025-01-16 21:43:49 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v3-0002-Trigger-more-frequent-autovacuums-with-relallfroz.patch) at 2024-10-25 15:14:19 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Add-relallfrozen-to-pg_class.patch) at 2024-10-23 21:21:14 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v1-0002-Trigger-more-frequent-autovacuums-with-relallfroz.patch) at 2024-10-22 19:12:53 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)

History

When	Who	What
2025-03-03 19:46:18	Melanie Plageman (melanieplageman)	Closed in commitfest 2025-03 with status: Committed
2025-03-03 19:46:18	Melanie Plageman (melanieplageman)	Changed committer to melanieplageman
2025-02-28 03:36:25	Nathan Bossart (bossartn)	Added bossartn as reviewer
2025-02-03 14:35:07	Melanie Plageman (melanieplageman)	Closed in commitfest 2025-01 with status: Moved to next CF
2024-12-02 14:04:07	Dmitry Dolgov (erthalion)	Closed in commitfest 2024-11 with status: Moved to next CF
2024-10-22 19:15:51	Melanie Plageman (melanieplageman)	Changed authors to Melanie Plageman (melanieplageman)
2024-10-22 19:15:42	Melanie Plageman (melanieplageman)	Attached mail thread CAAKRu_aj-P7YyBz_cPNwztz6ohP+vWis=iz3YcomkB3NpYA--w@mail.gmail.com
2024-10-22 19:15:42	Melanie Plageman (melanieplageman)	Created patch record