Trigger more frequent autovacuums for insert-heavy tables

Title

Topic

Performance

Created

2024-10-22 19:15:42

Last modified

2025-02-03 14:35:07 (3 hours, 58 minutes ago)

Latest email

2025-01-16 22:50:14 (2 weeks, 3 days ago)

Status

2025-03: Needs review

2025-01: Moved to next CF

2024-11: Moved to next CF

Target version

Authors

Melanie Plageman (melanieplageman)

Reviewers

Committer

Links

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

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-01-16 22:50:14 by Melanie Plageman <melanieplageman at gmail.com>
Latest attachment (v5-0002-Trigger-more-frequent-autovacuums-with-relallfroz.patch) at 2025-01-16 22:50:14 from Melanie Plageman <melanieplageman at gmail.com>
    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-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