addons/addons/postgresql-cluster/15/plans/standard-16c64g400/values.yaml at 7101ee5fd6310260e49341e2953a673f46a09b98 · drycc-addons/addons · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
## @param fullnameOverride String to fully override common.names.fullname template
##
fullnameOverride: hb-postgresql-cluster-standard-400

postgresql:
  config: |-
    # Connectivity
    max_connections = 2000
    superuser_reserved_connections = 3

    # Memory Settings
    shared_buffers = '16384 MB'
    work_mem = '32 MB'
    maintenance_work_mem = '520 MB'
    huge_pages = try   # NB! requires also activation of huge pages via kernel params, see here for more: https://www.postgresql.org/docs/current/static/kernel-resources.html#LINUX-HUGE-PAGES
    effective_cache_size = '45 GB'
    effective_io_concurrency = 100 # concurrent IO only really activated if OS supports posix_fadvise function
    random_page_cost = 1.25 # speed of random disk access relative to sequential access (1.0)

    # Monitoring
    track_io_timing=on        # measure exact block IO times
    track_functions=pl        # track execution times of pl-language procedures if any

    # Replication
    max_wal_senders = 10
    synchronous_commit = on

    # Checkpointing:
    checkpoint_timeout  = '30 min'
    checkpoint_completion_target = 0.9
    max_wal_size = '6 GB'
    min_wal_size = '2 GB'

    # WAL writing
    wal_compression = on
    wal_buffers = -1    # auto-tuned by Postgres till maximum of segment size (16MB by default)
    wal_writer_delay = 200ms
    wal_writer_flush_after = 1MB
    wal_keep_size = '10 GB'

    # Background writer
    bgwriter_delay = 200ms
    bgwriter_lru_maxpages = 100
    bgwriter_lru_multiplier = 2.0
    bgwriter_flush_after = 0

    # Parallel queries:
    max_worker_processes = 16
    max_parallel_workers_per_gather = 8
    max_parallel_maintenance_workers = 8
    max_parallel_workers = 16
    parallel_leader_participation = on

    # Advanced features
    enable_partitionwise_join = on
    enable_partitionwise_aggregate = on
    jit = on
    max_slot_wal_keep_size = 40GB
    track_wal_io_timing = on
    maintenance_io_concurrency = 100

resources:
  # If you do want to specify resources, uncomment the following
  # lines, adjust them as necessary, and remove the curly braces after 'resources:'.
  limits:
    cpu: 16000m
    memory: 64Gi
    hugepages-2Mi: 40Mi
  requests:
    cpu: 16000m
    memory: 64Gi

persistentVolume:
  enabled: true
  size: 400Gi