From: Kurt Roeckx <kurt@roeckx.be>
To: Rui DeSousa <rui@crazybean.net>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Append only tables
Date: Tue, 24 Mar 2020 23:02:02 +0100
Message-ID: <20200324220202.GN22330@roeckx.be> (raw)
In-Reply-To: <1B98792C-304F-4248-8B3F-7435F32B1551@crazybean.net>
References: <20200320215053.GH22330@roeckx.be>
<6299ca7d13bd6e3ba3fec9de173226a862b14585.camel@cybertec.at>
<20200324184151.GM22330@roeckx.be>
<1B98792C-304F-4248-8B3F-7435F32B1551@crazybean.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: kurt@roeckx.be, rui@crazybean.net, laurenz.albe@cybertec.at, pgsql-admin@lists.postgresql.org
Subject: Re: Append only tables
In-Reply-To: <20200324220202.GN22330@roeckx.be>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox