Re: Berserk Autovacuum (let's save next Mandrill)

On Wed, Mar 11, 2020 at 10:32:47AM +1300, David Rowley wrote:
> 2. The new feature can be completely disabled. This might be very
> useful for people who suffer from auto-vacuum starvation.

On Thu, Mar 12, 2020 at 08:28:05PM +1300, David Rowley wrote:
> Yes, but in particular so it can be completely disabled easily.

How is it disabled ?  By setting scale_factor=100 ?

+               {
                                                              
 
+                       "autovacuum_vacuum_insert_scale_factor",
                                                              
 
+                       "Number of tuple inserts prior to vacuum as a fraction of reltuples",
                                                              
 
+                       RELOPT_KIND_HEAP | RELOPT_KIND_TOAST,
                                                              
 
+                       ShareUpdateExclusiveLock
                                                              
 
+               },
                                                              
 
+               -1, 0.0, 100.0
                                                              
 

Note, vacuum_cleanup_index_scale_factor uses max: 1e10
See 4d54543efa5eb074ead4d0fadb2af4161c943044

-- 
Justin