Re: Fwd: PG12 autovac issues - Mailing list pgsql-general

From Michael Lewis
Subject Re: Fwd: PG12 autovac issues
Date
Msg-id CAHOFxGoDBxRfjm04K+qNH4sifrTaBM=_xQY8jA7AJjUgsvCurw@mail.gmail.com
Whole thread Raw
In response to Re: Fwd: PG12 autovac issues  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Fwd: PG12 autovac issues  (Justin King <kingpin867@gmail.com>)
List pgsql-general
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.

Also, is there any period of lower activity on your system that you could schedule a vacuum freeze for daily or weekly? I believe having frozen pages would also mean all the autovacuums would be able to skip more pages and therefore be faster.

>> autovacuum_vacuum_cost_delay = 20

This was changed to 2ms in PG12. You should reduce that most likely.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Fwd: PG12 autovac issues
Next
From: stan
Date:
Subject: Join help, please