Re: Append only tables

On Tue, Mar 24, 2020 at 04:59:39PM -0400, Rui DeSousa wrote:
> 
> 
> > On Mar 24, 2020, at 2:41 PM, Kurt Roeckx <kurt@roeckx.be> wrote:
> > 
> > I think I'll set autovacuum_freeze_max_age a lot lower than the default
> > 200 M.
> 
> Hmm… not sure what you really want to accomplish? 
> 
> Administrating a high volume database and went the other way; with it set to 800M; however, auto vacuum set
aggressively.

The only other setting I see is autovacuum_vacuum_threshold, which
only looks at updates and deletes.


Kurt