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

clog.c

  • Andres Freund's avatar
    5364b357
    Increase maximum number of clog buffers. · 5364b357
    Andres Freund authored
    Benchmarking has shown that the current number of clog buffers limits
    scalability. We've previously increased the number in 33aaa139, but
    that's not sufficient with a large number of clients.
    
    We've benchmarked the cost of increasing the limit by benchmarking worst
    case scenarios; testing showed that 128 buffers don't cause a
    regression, even in contrived scenarios, whereas 256 does
    
    There are a number of more complex patches flying around to address
    various clog scalability problems, but this is simple enough that we can
    get it into 9.6; and is beneficial even after those patches have been
    applied.
    
    It is a bit unsatisfactory to increase this in small steps every few
    releases, but a better solution seems to require a rewrite of slru.c;
    not something done quickly.
    
    Author: Amit Kapila and Andres Freund
    Discussion: CAA4eK1+-=18HOrdqtLXqOMwZDbC_15WTyHiFruz7BvVArZPaAw@mail.gmail.com
    5364b357
    History
    Increase maximum number of clog buffers.
    Andres Freund authored
    Benchmarking has shown that the current number of clog buffers limits
    scalability. We've previously increased the number in 33aaa139, but
    that's not sufficient with a large number of clients.
    
    We've benchmarked the cost of increasing the limit by benchmarking worst
    case scenarios; testing showed that 128 buffers don't cause a
    regression, even in contrived scenarios, whereas 256 does
    
    There are a number of more complex patches flying around to address
    various clog scalability problems, but this is simple enough that we can
    get it into 9.6; and is beneficial even after those patches have been
    applied.
    
    It is a bit unsatisfactory to increase this in small steps every few
    releases, but a better solution seems to require a rewrite of slru.c;
    not something done quickly.
    
    Author: Amit Kapila and Andres Freund
    Discussion: CAA4eK1+-=18HOrdqtLXqOMwZDbC_15WTyHiFruz7BvVArZPaAw@mail.gmail.com