Re: Fwd: PG12 autovac issues

On Thu, Mar 19, 2020 at 9:31 AM Justin King <kingpin867(at)gmail(dot)com> wrote:

> On Wed, Mar 18, 2020 at 1:40 PM Michael Lewis <mlewis(at)entrata(dot)com> wrote:
> >
> > Do you have default fillfactor set on this table? If not, I would wonder
> if reducing it to 50% or even 20% would allow many more HOT updates that
> would reduce bloat.
>
> I don't believe we have a default fillfactor, but I'm still trying to
> understand why autovacs would completely stop -- that seems like a
> bug. Especially since there was no change between PG10 and PG12 and
> this problem never existed there.
>

Is there any reason to not schedule vacuum freeze for each db daily? Just
curious.