On Wed, Nov 25, 2020 at 03:59:06PM +0100, Laurenz Albe wrote: > On Tue, 2020-11-24 at 11:34 -0600, Ron wrote: > > And if you're afraid of autovacuum and autoanalyze stealing resources, then > > disable them (at the table level). > > Ugh, bad advice. > > Better would be to VACUUM (FREEZE) these static table once, then autovacuum > won't ever perform resource consuming activities on them again.
Yes, also, even if you never do that, autovacuum will eventually freeze those tables and never access them again. -- Bruce Momjian <br...@momjian.us> https://momjian.us EnterpriseDB https://enterprisedb.com The usefulness of a cup is in its emptiness, Bruce Lee
