Re: Append only tables

From: Kurt Roeckx <kurt(at)roeckx(dot)be>
To: Rui DeSousa <rui(at)crazybean(dot)net>
Cc: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Append only tables
Date: 2020-03-24 22:02:02
Message-ID: 20200324220202.GN22330@roeckx.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)roeckx(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rui DeSousa 2020-03-24 23:01:08 Re: Append only tables
Previous Message Rui DeSousa 2020-03-24 20:59:39 Re: Append only tables