On Thu, Mar 19, 2020 at 9:31 AM Justin King <kingpin867@xxxxxxxxx> wrote:
On Wed, Mar 18, 2020 at 1:40 PM Michael Lewis <mlewis@xxxxxxxxxxx> 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.