Date: Tue, 10 Mar 2020 00:00:05 -0500
From: Justin Pryzby <pryzby@telsasoft.com>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: David Rowley <dgrowleyml@gmail.com>,
	Tomas Vondra <tomas.vondra@2ndquadrant.com>,
	Amit Kapila <amit.kapila16@gmail.com>,
	Masahiko Sawada <sawada.mshk@gmail.com>,
	Darafei =?utf-8?Q?Kom=D1=8Fpa?= Praliaskouski <me@komzpa.net>,
	Andres Freund <andres@anarazel.de>,
	PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>,
	Alvaro Herrera <alvherre@2ndquadrant.com>,
	Michael Banck <mbanck@gmx.net>
Subject: Re: Berserk Autovacuum (let's save next Mandrill)
Message-ID: <20200310050005.GA11448@telsasoft.com>
References: 
 <CAD21AoAap+b+o+LMjHbOb2hn3CrjCGrVYHPv7TpG8G07dCk+VQ@mail.gmail.com>
 <CAA4eK1JnHr0ppUEmK7gFF-57z2Z5q2mCUWZf4tVWVHGeStM9tg@mail.gmail.com>
 <20200107180524.mqz456t2pmr7crpw@development>
 <98a1422dece118877ebbdc20cb78209f6d12866e.camel@cybertec.at>
 <0cd8685047ac86fdf9c5446a24ff3aed8755e290.camel@cybertec.at>
 <2207744f6cc70813d9000510b6bf03ce85db6675.camel@cybertec.at>
 <CAApHDvrUQazEd3F491ubZzU65B=e=O37bPcvXtPAH5vSn+9YUw@mail.gmail.com>
 <602873766faa0e9200a60dcc26dc10c636761d5d.camel@cybertec.at>
 <CAApHDvrdVpYQUqk5uTR-iVwnW=JbEwX86zngCj5v06Ug77MPVw@mail.gmail.com>
 <91c110aad4b8653d6433d42fd707bd16074c79a5.camel@cybertec.at>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <91c110aad4b8653d6433d42fd707bd16074c79a5.camel@cybertec.at>
User-Agent: Mutt/1.5.24 (2015-08-30)
Precedence: bulk

> +++ b/src/backend/utils/misc/postgresql.conf.sample
> +#autovacuum_vacuum_insert_threshold = 10000000	# min number of row inserts
> +					# before vacuum

Similar to a previous comment [0] about reloptions or GUC:

Can we say "threshold number of insertions before vacuum" ?
..or "maximum number of insertions before triggering autovacuum"

-- 
Justin

[0] https://www.postgresql.org/message-id/602873766faa0e9200a60dcc26dc10c636761d5d.camel%40cybertec.at