Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1jGsXt-0005FR-5r
	for pgsql-admin@arkaria.postgresql.org; Tue, 24 Mar 2020 23:01:17 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1jGsXq-0008QE-Bz
	for pgsql-admin@arkaria.postgresql.org; Tue, 24 Mar 2020 23:01:14 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <rui@crazybean.net>)
	id 1jGsXp-0008Q7-Va
	for pgsql-admin@lists.postgresql.org; Tue, 24 Mar 2020 23:01:14 +0000
Received: from impout002aa.msg.chrl.nc.charter.net ([47.43.20.26]
 helo=impout002.msg.chrl.nc.charter.net)
	by makus.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <rui@crazybean.net>)
	id 1jGsXn-0000XP-MS
	for pgsql-admin@lists.postgresql.org; Tue, 24 Mar 2020 23:01:12 +0000
Received: from cerberus.crazybean.net ([24.151.69.73])
	by cmsmtp with ESMTP
	id GsXljhj60h15uGsXljE2m7; Tue, 24 Mar 2020 23:01:10 +0000
Authentication-Results: crazybean.net; none
X-Authority-Analysis: v=2.3 cv=etJrMbhX c=1 sm=1 tr=0
 a=YXTuGtgWN9YX+aIhe8tYuA==:117 a=YXTuGtgWN9YX+aIhe8tYuA==:17
 a=jpOVt7BSZ2e4Z31A5e1TngXxSK0=:19 a=xqWC_Br6kY4A:10 a=kj9zAlcOel0A:10
 a=SS2py6AdgQ4A:10 a=z84j4BlIXpVL5vYcdH4A:9 a=CjuIK1q_8ugA:10
 a=nQbtkkMzsqAA:10
Received: from [IPv6:2001:470:e117:4:e12a:29ba:ce:b015] (<unknown>
 [2001:470:e117:4:e12a:29ba:ce:b015])
	by cerberus.crazybean.net (OpenSMTPD) with ESMTPSA id 1cfbf76c
 (TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256:NO);
	Tue, 24 Mar 2020 19:01:09 -0400 (EDT)
Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 13.0 \(3608.60.0.2.5\))
Subject: Re: Append only tables
From: Rui DeSousa <rui@crazybean.net>
In-Reply-To: <20200324220202.GN22330@roeckx.be>
Date: Tue, 24 Mar 2020 19:01:08 -0400
Cc: Laurenz Albe <laurenz.albe@cybertec.at>,
 pgsql-admin@lists.postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <7BE498E9-0108-4D32-AAA8-6ECBC8257BAA@crazybean.net>
References: <20200320215053.GH22330@roeckx.be>
 <6299ca7d13bd6e3ba3fec9de173226a862b14585.camel@cybertec.at>
 <20200324184151.GM22330@roeckx.be>
 <1B98792C-304F-4248-8B3F-7435F32B1551@crazybean.net>
 <20200324220202.GN22330@roeckx.be>
To: Kurt Roeckx <kurt@roeckx.be>
X-Mailer: Apple Mail (2.3608.60.0.2.5)
X-CMAE-Envelope: 
 MS4wfIYpS+puL3AomFIB8cpYVjB4sZut/MmapsGAG+9PU8VHNo8MvCfcpFINEBhEMs7awM+fY8YTmfIQLWGEU1tXX+LPuwRatjZhvqbC08nL40f7xYnRC96c
 ky1IN3Fpp8AGNmJPw19sz+5jVgvn+N/l7ChtuRsmQQElvnTNNnT6xUxxhQWvuGY1qhqowGuF4US1QbddMh77D2HYbxiCZWxS6EmF1HFp53X/u4JQ1LNEadAs
 rkb+dVueQctF1f42HtEpTQ==
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Precedence: bulk


> On Mar 24, 2020, at 6:02 PM, Kurt Roeckx <kurt@roeckx.be> wrote:
>=20
>=20
> The only other setting I see is autovacuum_vacuum_threshold, which
> only looks at updates and deletes.
>=20


Is it just the one table? Might want to set autovacuum_freeze_max_age on =
the table itself.