• Tom Lane's avatar
    Convert [autovacuum_]vacuum_cost_delay into floating-point GUCs. · caf626b2
    Tom Lane authored
    This change makes it possible to specify sub-millisecond delays,
    which work well on most modern platforms, though that was not true
    when the cost-delay feature was designed.
    
    To support this without breaking existing configuration entries,
    improve guc.c to allow floating-point GUCs to have units.  Also,
    allow "us" (microseconds) as an input/output unit for time-unit GUCs.
    (It's not allowed as a base unit, at least not yet.)
    
    Likewise change the autovacuum_vacuum_cost_delay reloption to be
    floating-point; this forces a catversion bump because the layout of
    StdRdOptions changes.
    
    This patch doesn't in itself change the default values or allowed
    ranges for these parameters, and it should not affect the behavior
    for any already-allowed setting for them.
    
    Discussion: https://postgr.es/m/1798.1552165479@sss.pgh.pa.us
    caf626b2
create_table.sgml 84.8 KB