On Mon, 2019-09-23 at 13:53 -0600, Michael Lewis wrote:
> > - For tables that receive only INSERTs, schedule a regular VACUUM
> > with "cron" or similar. Unfortunately, PostgreSQL isn't very
> > smart
> > about vacuuming insert-only tables.
>
>
> What is the need to vacuum on an insert only table? Does that just
> maintain the freespace map?
No, the idea is to get rows frozen *before* autovacuum launches
an anti-wraparound vacuum.
You could launch VACUUM (FREEZE) for best effect.
This way you can schedule the operation so that it doesn't
interfere with your other activities.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com