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

postgresql.conf.sample

Blame
    • Andres Freund's avatar
      a0f5954a
      Increase max_wal_size's default from 128MB to 1GB. · a0f5954a
      Andres Freund authored
      The introduction of min_wal_size & max_wal_size in 88e98230 makes it
      feasible to increase the default upper bound in checkpoint
      size. Previously raising the default would lead to a increased disk
      footprint, even if more segments weren't beneficial.  The low default of
      checkpoint size is one of common performance problem users have thus
      increasing the default makes sense.  Setups where the increase in
      maximum disk usage is a problem will very likely have to run with a
      modified configuration anyway.
      
      Discussion: 54F4EFB8.40202@agliodbs.com,
          CA+TgmoZEAgX5oMGJOHVj8L7XOkAe05Gnf45rP40m-K3FhZRVKg@mail.gmail.com
      
      Author: Josh Berkus, after a discussion involving lots of people.
      a0f5954a
      History
      Increase max_wal_size's default from 128MB to 1GB.
      Andres Freund authored
      The introduction of min_wal_size & max_wal_size in 88e98230 makes it
      feasible to increase the default upper bound in checkpoint
      size. Previously raising the default would lead to a increased disk
      footprint, even if more segments weren't beneficial.  The low default of
      checkpoint size is one of common performance problem users have thus
      increasing the default makes sense.  Setups where the increase in
      maximum disk usage is a problem will very likely have to run with a
      modified configuration anyway.
      
      Discussion: 54F4EFB8.40202@agliodbs.com,
          CA+TgmoZEAgX5oMGJOHVj8L7XOkAe05Gnf45rP40m-K3FhZRVKg@mail.gmail.com
      
      Author: Josh Berkus, after a discussion involving lots of people.