Re: Append only tables - Mailing list pgsql-admin

From Kurt Roeckx
Subject Re: Append only tables
Date
Msg-id 20200324220202.GN22330@roeckx.be
Whole thread Raw
In response to Re: Append only tables  (Rui DeSousa <rui@crazybean.net>)
Responses Re: Append only tables
List pgsql-admin
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




pgsql-admin by date:

Previous
From: Rui DeSousa
Date:
Subject: Re: Append only tables
Next
From: Rui DeSousa
Date:
Subject: Re: Append only tables