forked from zalando/postgres-operator
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathpg-16c32g.yml
More file actions
76 lines (76 loc) · 2.13 KB
/
Copy pathpg-16c32g.yml
File metadata and controls
76 lines (76 loc) · 2.13 KB
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
76
apiVersion: acid.zalan.do/v1
kind: postgresql
metadata:
annotations:
acid.zalan.do/controller: postgres-operator
name: pg-16c32g
spec:
connectionPooler:
maxDBConnections: 3000
numberOfInstances: 6
databases:
kubernetes: kubernetes
enableConnectionPooler: true
enableLogicalBackup: false
enableMasterLoadBalancer: false
enableMasterPoolerLoadBalancer: false
enableReplicaConnectionPooler: false
enableReplicaLoadBalancer: false
enableReplicaPoolerLoadBalancer: false
enableShmVolume: true
env:
- name: TZ
value: Asia/Shanghai
- name: SPILO_PROVIDER
value: local
nodeAffinity:
requiredDuringSchedulingIgnoredDuringExecution:
nodeSelectorTerms:
- matchExpressions:
- key: pg
operator: In
values:
- spilo
numberOfInstances: 2
patroni:
failsafe_mode: true
pg_hba: # https://www.postgresql.org/docs/current/auth-pg-hba-conf.html
- local all all peer
- local replication all scram-sha-256
- host all,replication all all scram-sha-256
postgresql:
# SAN: effective_io_concurrency/random_page_cost=300/1.1
# SSD: effective_io_concurrency/random_page_cost=200/1.1
# HDD: effective_io_concurrency/random_page_cost=2/4
parameters: # https://pgtune.leopard.in.ua
checkpoint_completion_target: "0.9"
default_statistics_target: "100"
effective_cache_size: 24GB
effective_io_concurrency: "200"
huge_pages: "try"
maintenance_work_mem: 2GB
max_connections: "5000"
max_parallel_maintenance_workers: "6"
max_parallel_workers: "16"
max_parallel_workers_per_gather: "6"
max_wal_size: 4GB
max_worker_processes: "16"
min_wal_size: 1GB
password_encryption: scram-sha-256
random_page_cost: "1.1"
shared_buffers: 8GB
wal_buffers: 16MB
work_mem: 1536kB
version: "14"
resources:
limits:
cpu: "16"
memory: 32Gi
requests:
cpu: "16"
memory: 32Gi
teamId: k8s
users: # (no)bypassrls createdb createrole inherit login replication superuser
kubernetes: []
volume:
size: 150Gi