Re: Trigger more frequent autovacuums of heavy insert tables

Melanie Plageman <melanieplageman@gmail.com>

From: Melanie Plageman <melanieplageman@gmail.com>

To: Greg Sabino Mullane <htamfids@gmail.com>

Cc: Pg Hackers <pgsql-hackers@postgresql.org>, Robert Haas <robertmhaas@gmail.com>, Andres Freund <andres@anarazel.de>, Peter Geoghegan <pg@bowt.ie>, David Rowley <dgrowley@gmail.com>

Date: 2025-01-16T22:50:14Z

Lists: pgsql-hackers

Attachments

v5-0002-Trigger-more-frequent-autovacuums-with-relallfroz.patch (application/octet-stream) patch v5-0002
v5-0001-Add-relallfrozen-to-pg_class.patch (application/octet-stream) patch v5-0001

On Thu, Jan 16, 2025 at 4:43 PM Melanie Plageman
<melanieplageman@gmail.com> wrote:
>
> On Fri, Oct 25, 2024 at 11:14 AM Melanie Plageman
> <melanieplageman@gmail.com> wrote:
> >
> > I've done something similar to this in attached v2.
>
> This needed a rebase. See attached v4.

Whoops -- docs didn't build. Attached v5.

- Melanie

Commits

doc: Update formula for vacuum insert threshold.
- cbdce71b9984 19 (unreleased) landed
- c99436f43322 18.2 landed
Redefine pg_class.reltuples to be -1 before the first VACUUM or ANALYZE.
- 3d351d916b20 14.0 cited
Measure the number of all-visible pages for use in index-only scan costing.
- e6858e665731 9.2.0 cited