Skip to content
Snippets Groups Projects
Select Git revision
  • benchmark-tools
  • postgres-lambda
  • master default
  • REL9_4_25
  • REL9_5_20
  • REL9_6_16
  • REL_10_11
  • REL_11_6
  • REL_12_1
  • REL_12_0
  • REL_12_RC1
  • REL_12_BETA4
  • REL9_4_24
  • REL9_5_19
  • REL9_6_15
  • REL_10_10
  • REL_11_5
  • REL_12_BETA3
  • REL9_4_23
  • REL9_5_18
  • REL9_6_14
  • REL_10_9
  • REL_11_4
23 results

miscadmin.h

  • Alvaro Herrera's avatar
    e2a186b0
    Add a multi-worker capability to autovacuum. This allows multiple worker · e2a186b0
    Alvaro Herrera authored
    processes to be running simultaneously.  Also, now autovacuum processes do not
    count towards the max_connections limit; they are counted separately from
    regular processes, and are limited by the new GUC variable
    autovacuum_max_workers.
    
    The launcher now has intelligence to launch workers on each database every
    autovacuum_naptime seconds, limited only on the max amount of worker slots
    available.
    
    Also, the global worker I/O utilization is limited by the vacuum cost-based
    delay feature.  Workers are "balanced" so that the total I/O consumption does
    not exceed the established limit.  This part of the patch was contributed by
    ITAGAKI Takahiro.
    
    Per discussion.
    e2a186b0
    History
    Add a multi-worker capability to autovacuum. This allows multiple worker
    Alvaro Herrera authored
    processes to be running simultaneously.  Also, now autovacuum processes do not
    count towards the max_connections limit; they are counted separately from
    regular processes, and are limited by the new GUC variable
    autovacuum_max_workers.
    
    The launcher now has intelligence to launch workers on each database every
    autovacuum_naptime seconds, limited only on the max amount of worker slots
    available.
    
    Also, the global worker I/O utilization is limited by the vacuum cost-based
    delay feature.  Workers are "balanced" so that the total I/O consumption does
    not exceed the established limit.  This part of the patch was contributed by
    ITAGAKI Takahiro.
    
    Per discussion.