/
gis.yaml
95 lines (95 loc) · 2.19 KB
/
gis.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
name: Geospatial
description: Postgres for geospatial workloads.
repository: "quay.io/tembo"
organization: tembo
images:
14: "geo-cnpg:14-8f5366e"
15: "geo-cnpg:15-8f5366e"
16: "geo-cnpg:16-8f5366e"
stack_version: 0.1.0
compute_templates:
- cpu: 0.25
memory: 1Gi
instance_class: GeneralPurpose
- cpu: 0.5
memory: 2Gi
instance_class: GeneralPurpose
- cpu: 1
memory: 4Gi
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: 0.5
memory: 1Gi
instance_class: ComputeOptimized
- cpu: 1
memory: 2Gi
instance_class: ComputeOptimized
- 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: 1
memory: 8Gi
instance_class: MemoryOptimized
- cpu: 2
memory: 16Gi
instance_class: MemoryOptimized
- cpu: 4
memory: 32Gi
instance_class: MemoryOptimized
postgres_config_engine: standard
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: pg_stat_statements.track
value: all
- name: shared_preload_libraries
value: pg_stat_statements
trunk_installs:
- name: fuzzystrmatch
version: 1.2.0
- name: pg_stat_statements
version: 1.10.0
extensions:
- name: pg_stat_statements
locations:
- database: postgres
enabled: true
version: 1.10.0
- name: postgis
locations:
- database: postgres
enabled: true
version: 3.4.0