2021-03-22 13:13:59 +01:00
|
|
|
Role Name
|
|
|
|
=========
|
|
|
|
|
2023-11-21 12:07:55 +01:00
|
|
|
A role that installs a TimeScaleDB instance. See <https://docs.timescale.com/self-hosted/latest/install/installation-linux/>
|
2021-03-22 13:13:59 +01:00
|
|
|
|
|
|
|
Role Variables
|
|
|
|
--------------
|
|
|
|
|
2021-03-23 15:35:03 +01:00
|
|
|
The most important variables are listed below:
|
|
|
|
|
|
|
|
``` yaml
|
2023-11-21 12:07:55 +01:00
|
|
|
timescale_db_ubuntu_repo: 'deb https://packagecloud.io/timescale/timescaledb/ubuntu/ $(lsb_release -c -s) main'
|
2021-03-23 15:36:15 +01:00
|
|
|
timescale_db_pkg: 'timescaledb-2-postgresql-{{ psql_version }}'
|
|
|
|
timescale_db_deb_pkgs: '{{ timescale_db_pkg }}'
|
|
|
|
|
|
|
|
timescale_db_el_pkgs:
|
|
|
|
- '{{ timescale_db_pkg }}'
|
|
|
|
- libpq5-devel
|
|
|
|
|
|
|
|
timescaledb_configuration_settings:
|
|
|
|
- { name: 'timescaledb.last_tuned', value: "'{{ ansible_date_time.date }}T{{ ansible_date_time.time }}{{ ansible_date_time.tz_offset }}'", set: 'True' }
|
2023-11-21 12:07:55 +01:00
|
|
|
# - { name: 'timescaledb.last_tuned_version', value: "'0.11.0'", set: 'True' }
|
2021-03-23 15:36:15 +01:00
|
|
|
- { name: 'timescaledb.max_background_workers', value: '{{ ansible_processor_vcpus * 2 }}', set: 'True' }
|
|
|
|
- { name: 'max_worker_processes', value: '{{ (ansible_processor_vcpus * 4) - 1 }}', set: 'True' }
|
|
|
|
- { name: 'max_parallel_workers_per_gather', value: '{{ (ansible_processor_vcpus / 2) | int }}', set: 'True' }
|
|
|
|
- { name: 'max_parallel_workers ', value: '{{ ansible_processor_vcpus }}', set: 'True' }
|
|
|
|
- { name: 'default_statistics_target', value: '{{ (ansible_memtotal_mb / 16) | int }}', set: 'True' }
|
|
|
|
- { name: 'random_page_cost', value: '1.1', set: 'True' }
|
|
|
|
- { name: 'checkpoint_completion_target', value: '0.9', set: 'True' }
|
|
|
|
- { name: 'max_locks_per_transaction', value: '{{ ((ansible_memtotal_mb / 512) * ansible_processor_vcpus) | int }}', set: 'True' }
|
|
|
|
- { name: 'effective_io_concurrency', value: '200', set: 'True' }
|
2021-03-23 15:35:03 +01:00
|
|
|
```
|
2021-03-22 13:13:59 +01:00
|
|
|
|
|
|
|
Dependencies
|
|
|
|
------------
|
|
|
|
|
2021-03-23 15:35:03 +01:00
|
|
|
None
|
2021-03-22 13:13:59 +01:00
|
|
|
|
|
|
|
License
|
|
|
|
-------
|
|
|
|
|
|
|
|
EUPL-1.2
|
|
|
|
|
|
|
|
Author Information
|
|
|
|
------------------
|
|
|
|
|
2021-03-23 15:35:03 +01:00
|
|
|
Andrea Dell'Amico, <andrea.dellamico@isti.cnr.it>
|