Trigger more frequent autovacuums for insert-heavy tables

Title

Topic

Performance

Created

2024-10-22 19:15:42

Last modified

2024-10-22 19:15:51 (4 weeks, 1 day ago)

Latest email

2024-10-25 15:14:19 (3 weeks, 5 days ago)

Status

2024-11: Needs review

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 2024-10-25 15:14:19 by Melanie Plageman <melanieplageman at gmail.com>
Latest attachment (v3-0002-Trigger-more-frequent-autovacuums-with-relallfroz.patch) at 2024-10-25 15:14:19 from Melanie Plageman <melanieplageman at gmail.com>
    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
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