pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
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: Wed, 25 Mar 2020 00:04:03 +0100
Message-ID: <20200324230403.GO22330@roeckx.be> (raw)
In-Reply-To: <7BE498E9-0108-4D32-AAA8-6ECBC8257BAA@crazybean.net>
References: <20200320215053.GH22330@roeckx.be>
	<6299ca7d13bd6e3ba3fec9de173226a862b14585.camel@cybertec.at>
	<20200324184151.GM22330@roeckx.be>
	<1B98792C-304F-4248-8B3F-7435F32B1551@crazybean.net>
	<20200324220202.GN22330@roeckx.be>
	<7BE498E9-0108-4D32-AAA8-6ECBC8257BAA@crazybean.net>

On Tue, Mar 24, 2020 at 07:01:08PM -0400, Rui DeSousa wrote:
> 
> > On Mar 24, 2020, at 6:02 PM, Kurt Roeckx <kurt@roeckx.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






view thread (13+ messages)

Message-ID: <20200324230403.GO22330@roeckx.be>
Permalink:  ../20200324230403.GO22330@roeckx.be/
Also on:    postgresql.org/message-id/20200324230403.GO22330@roeckx.be

 · 

reply
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: <20200324230403.GO22330@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