• Thomas Munro's avatar
    Adjust DSM and DSA slot usage constants. · d061ea21
    Thomas Munro authored
    When running a lot of large parallel queries concurrently, or a plan with
    a lot of separate Gather nodes, it is possible to run out of DSM slots.
    There are better solutions to these problems requiring architectural
    redesign work, but for now, let's adjust the constants so that it's more
    difficult to hit the limit.
    
    1.  Previously, a DSA area would create up to four segments at each size
    before doubling the size.  After this commit, it will create only two at
    each size, so it ramps up faster and therefore needs fewer slots.
    
    2.  Previously, the total limit on DSM slots allowed for 2 per connection.
    Switch to 5 per connection.
    
    Also remove an obsolete nearby comment.
    
    Author: Thomas Munro
    Reviewed-by: Robert Haas, Andres Freund
    Discussion: https://postre.es/m/CA%2BhUKGL6H2BpGbiF7Lj6QiTjTGyTLW_vLR%3DSn2tEBeTcYXiMKw%40mail.gmail.com
    d061ea21
dsa.c 75.8 KB