This repository has been archived by the owner on Dec 5, 2023. It is now read-only.
/
data_warehouse.yaml
98 lines (98 loc) · 2.17 KB
/
data_warehouse.yaml
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
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
name: DataWarehouse
description: A Postgres instance equipped with configuration and extensions building a data warehouse on Postgres.
image: "quay.io/tembo/dw-cnpg:15.3.0-1-0baf38f"
stack_version: 0.1.0
compute_templates:
- cpu: 2
memory: 4Gi
- cpu: 2
memory: 8Gi
- cpu: 4
memory: 16Gi
- cpu: 8
memory: 32Gi
- cpu: 16
memory: 32Gi
postgres_config_engine: olap
postgres_config:
- name: autovacuum_vacuum_scale_factor
value: 0.05
- name: autovacuum_vacuum_insert_scale_factor
value: 0.05
- name: checkpoint_completion_target
value: 0.95
- name: checkpoint_timeout
value: 30min
- name: cron.host
value: /controller/run
- name: pg_stat_statements.track
value: top
- name: shared_preload_libraries
value: pg_stat_statements,pg_cron
- name: track_io_timing
value: 'on'
- name: wal_level
value: logical
trunk_installs:
- name: pg_stat_statements
version: 1.10.0
- name: hydra_columnar
version: 1.0.0
- name: pg_partman
version: 4.7.3
- name: pg_cron
version: 1.5.2
- name: postgres_fdw
version: 1.1.0
- name: redis_fdw
version: 1.0.0
- name: wrappers
version: 0.1.15
- name: multicorn
version: 2.5.0
extensions:
- name: pg_stat_statements
locations:
- database: postgres
enabled: true
version: 1.10.0
- name: columnar
locations:
- database: postgres
enabled: true
version: '11.1-7'
- name: pg_partman
locations:
- database: postgres
enabled: true
version: 4.7.3
- name: pg_cron
description: pg_cron
locations:
- database: postgres
enabled: true
version: 1.5.2
- name: postgres_fdw
description: postgres_fdw
locations:
- database: postgres
enabled: true
version: '1.1'
- name: redis_fdw
description: redis_fdw
locations:
- database: postgres
enabled: true
version: 1.0.0
- name: wrappers
description: wrappers
locations:
- database: postgres
enabled: true
version: 0.1.15
- name: multicorn
description: multicorn
locations:
- database: postgres
enabled: true
version: 2.5.0