Re: Trigger more frequent autovacuums of heavy insert tables

From:	Melanie Plageman <melanieplageman(at)gmail(dot)com>
To:	Greg Sabino Mullane <htamfids(at)gmail(dot)com>
Cc:	Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, Robert Haas <robertmhaas(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Peter Geoghegan <pg(at)bowt(dot)ie>, David Rowley <dgrowley(at)gmail(dot)com>
Subject:	Re: Trigger more frequent autovacuums of heavy insert tables
Date:	2025-01-16 21:43:49
Message-ID:	CAAKRu_Yep1JCnvrrZuSLjbJi13GtEkO+_NYSYOOpCMSYK3+mAA@mail.gmail.com
Views:	Whole Thread | Raw Message | Download mbox | Resend email
Thread:	2024-10-22 19:12:53 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎  2024-10-23 21:21:14 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎   2024-10-24 19:51:04 from Greg Sabino Mullane <htamfids(at)gmail(dot)com>    2024-10-25 15:14:19 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎     2025-01-16 21:43:49 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎      2025-01-16 22:50:14 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎       2025-02-05 22:08:09 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎        2025-02-06 01:54:07 from wenhui qiu <qiuwenhuifx(at)gmail(dot)com>         2025-02-06 15:42:43 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎          2025-02-07 06:40:22 from wenhui qiu <qiuwenhuifx(at)gmail(dot)com>          2025-02-07 07:54:20 from Japin Li <japinli(at)hotmail(dot)com>  2025-02-07 17:37:18 from Nathan Bossart <nathandbossart(at)gmail(dot)com>   2025-02-07 19:21:07 from Melanie Plageman <melanieplageman(at)gmail(dot)com>    2025-02-07 20:38:43 from Nathan Bossart <nathandbossart(at)gmail(dot)com>     2025-02-07 20:57:49 from Melanie Plageman <melanieplageman(at)gmail(dot)com>      2025-02-07 21:05:09 from Nathan Bossart <nathandbossart(at)gmail(dot)com>       2025-02-17 16:11:43 from Nathan Bossart <nathandbossart(at)gmail(dot)com>        2025-02-19 21:36:05 from Melanie Plageman <melanieplageman(at)gmail(dot)com>         2025-02-19 21:59:54 from Nathan Bossart <nathandbossart(at)gmail(dot)com>          2025-02-21 00:35:32 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎           2025-02-24 21:53:48 from Nathan Bossart <nathandbossart(at)gmail(dot)com>            2025-02-24 23:35:18 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎             2025-02-25 03:30:04 from wenhui qiu <qiuwenhuifx(at)gmail(dot)com>              2025-02-25 15:21:01 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎             2025-02-25 15:38:48 from Robert Haas <robertmhaas(at)gmail(dot)com>              2025-02-25 16:02:40 from Melanie Plageman <melanieplageman(at)gmail(dot)com>               2025-02-25 16:31:56 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                2025-02-25 17:36:40 from Robert Treat <rob(at)xzilla(dot)net>                 2025-02-25 18:05:10 from Nathan Bossart <nathandbossart(at)gmail(dot)com>               2025-02-25 16:36:04 from Greg Sabino Mullane <htamfids(at)gmail(dot)com>                2025-02-25 21:29:31 from Melanie Plageman <melanieplageman(at)gmail(dot)com>                 2025-02-26 16:17:06 from Robert Treat <rob(at)xzilla(dot)net>                  2025-02-26 17:25:13 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                   2025-02-26 21:48:20 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                    2025-02-28 17:54:02 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                     2025-03-01 00:57:52 from wenhui qiu <qiuwenhuifx(at)gmail(dot)com>                      2025-03-01 17:50:56 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                     2025-03-03 17:18:37 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                      2025-03-03 18:11:37 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                       2025-03-03 19:47:33 from Melanie Plageman <melanieplageman(at)gmail(dot)com>                        2025-11-11 18:48:39 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                         2025-11-18 20:20:51 from Nathan Bossart <nathandbossart(at)gmail(dot)com> 📎                          2025-11-18 21:30:14 from Melanie Plageman <melanieplageman(at)gmail(dot)com>                           2025-11-19 16:08:37 from Nathan Bossart <nathandbossart(at)gmail(dot)com>               2025-02-25 18:52:28 from Robert Haas <robertmhaas(at)gmail(dot)com>                2025-02-25 20:05:22 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                 2025-02-25 22:19:30 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                  2025-02-25 22:33:27 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                2025-02-25 22:13:09 from Melanie Plageman <melanieplageman(at)gmail(dot)com>              2025-02-25 16:06:59 from Nathan Bossart <nathandbossart(at)gmail(dot)com>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v4-0001-Add-relallfrozen-to-pg_class.patch	application/octet-stream	16.0 KB
v4-0002-Trigger-more-frequent-autovacuums-with-relallfroz.patch	application/octet-stream	5.2 KB

In response to

• Re: Trigger more frequent autovacuums of heavy insert tables at 2024-10-25 15:14:19 from Melanie Plageman

Responses

• Re: Trigger more frequent autovacuums of heavy insert tables at 2025-01-16 22:50:14 from Melanie Plageman

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Peter Smith	2025-01-16 22:09:27	Re: Log a warning in pg_createsubscriber for max_slot_wal_keep_size
Previous Message	Tom Lane	2025-01-16 21:40:20	Re: Eager aggregation, take 3