controller 0.59.0

Tembo Operator for Postgres
Documentation 
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

apiVersion: coredb.io/v1alpha1
kind: CoreDB
metadata:
  name: sample-oltp
spec:
  image: "quay.io/tembo/standard-cnpg:15-a0a5ab5"
  stop: false
  stack:
    name: OLTP
    postgres_config:
      - name: autovacuum_vacuum_cost_limit
        value: "-1"
      - name: autovacuum_vacuum_scale_factor
        value: "0.05"
      - name: autovacuum_vacuum_insert_scale_factor
        value: "0.05"
      - name: autovacuum_analyze_scale_factor
        value: "0.05"
      - name: checkpoint_timeout
        value: "10min"
      - name: track_activity_query_size
        value: "2048"
      - name: wal_compression
        value: "on"
      - name: track_io_timing
        value: "on"
      - name: log_min_duration_statement # https://www.postgresql.org/docs/15/runtime-config-logging.html
        value: "1000"
      - name: auto_explain.log_min_duration
        value: "1000ms"
      - name: statement_timeout
        value: "86400000"
      - name: pg_stat_statements.track
        value: "top"
      - name: shared_preload_libraries
        value: pg_stat_statements,auto_explain
  trunk_installs:
    - name: pg_stat_statements
      version: 1.10.0
  extensions:
    - name: pg_stat_statements
      locations:
        - database: postgres
          enabled: true
          version: 1.10.0
  runtime_config:
    - name: shared_buffers
      value: 1024MB
    - name: max_connections
      value: "431"
    - name: work_mem
      value: "5MB"
    - name: bgwriter_delay
      value: "200ms"
    - name: effective_cache_size
      value: "2867MB"
    - name: maintenance_work_mem
      value: "204MB"
    - name: max_wal_size
      value: "2GB"