On Thu, Mar 19, 2020 at 9:31 AM Justin King <kingpin...@gmail.com> wrote:
> On Wed, Mar 18, 2020 at 1:40 PM Michael Lewis <mle...@entrata.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.
