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 23:04:03
Message-ID: 20200324230403.GO22330@roeckx.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, Mar 24, 2020 at 07:01:08PM -0400, Rui DeSousa wrote:
>
> > On Mar 24, 2020, at 6:02 PM, Kurt Roeckx <kurt(at)roeckx(dot)be> wrote:
> >
> >
> > The only other setting I see is autovacuum_vacuum_threshold, which
> > only looks at updates and deletes.
>
> Is it just the one table? Might want to set autovacuum_freeze_max_age on the table itself.

That is at least what I meant. And it would be for at least 2
tables.

Kurt

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message androxkentaki . 2020-03-25 08:23:52 pgAdmin 4
Previous Message Rui DeSousa 2020-03-24 23:01:08 Re: Append only tables