/
data_warehouse.yaml
140 lines (140 loc) · 3.16 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
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
name: DataWarehouse
description: A Postgres instance equipped with configuration and extensions for building a data warehouse on Postgres.
repository: "quay.io/tembo"
organization: tembo
images:
14: "dw-cnpg:14-ed6e9e9"
15: "dw-cnpg:15-ed6e9e9"
16: "dw-cnpg:16-ed6e9e9"
stack_version: 0.1.0
compute_templates:
- cpu: 0.25
memory: 1Gi
instance_class: GeneralPurpose
- cpu: 2
memory: 8Gi
instance_class: GeneralPurpose
- cpu: 4
memory: 16Gi
instance_class: GeneralPurpose
- cpu: 8
memory: 32Gi
instance_class: GeneralPurpose
- cpu: 2
memory: 4Gi
instance_class: ComputeOptimized
- cpu: 4
memory: 8Gi
instance_class: ComputeOptimized
- cpu: 8
memory: 16Gi
instance_class: ComputeOptimized
- cpu: 0.5
memory: 4Gi
instance_class: MemoryOptimized
- cpu: 2
memory: 16Gi
instance_class: MemoryOptimized
- cpu: 4
memory: 32Gi
instance_class: MemoryOptimized
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,pg_later
- name: track_io_timing
value: "on"
- name: wal_level
value: logical
- name: pglater.host
value: postgresql:///postgres?host=/controller/run
trunk_installs:
- name: pg_stat_statements
version: 1.10.0
- name: hydra_columnar
version: 1.1.1
- name: pg_later
version: 0.1.0
- name: pg_partman
version: 4.7.4
- name: pg_cron
version: 1.6.2
- name: postgres_fdw
version: 1.1.0
- name: redis_fdw
version: 1.0.0
- name: wrappers
version: 0.2.0
- name: multicorn
version: 2.5.0
- name: pg_tier
version: 0.0.3
extensions:
- name: pg_stat_statements
locations:
- database: postgres
enabled: true
version: 1.10.0
- name: columnar
locations:
- database: postgres
enabled: true
version: "11.1-10"
- name: pg_later
locations:
- database: postgres
enabled: true
version: 0.1.0
- name: pg_partman
locations:
- database: postgres
enabled: true
version: 4.7.4
- name: pg_cron
description: pg_cron
locations:
- database: postgres
enabled: true
version: 1.6.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.2.0
- name: multicorn
description: multicorn
locations:
- database: postgres
enabled: true
version: 2.5.0
- name: pg_tier
description: pg_tier
locations:
- database: postgres
enabled: true
version: 0.0.3