参考
[https://yq.aliyun.com/articles/73537]
[https://www.timescale.com/]
[https://github.com/digoal/blog/blob/master/201801/20180129_01.md]
官方说明文档
安装
必须组件安装
下载软件包 && 编译安装
配置postgresql.conf(在数据库启动时自动加载timescale lib库)
创建扩展
timescaledb的相关参数
name | setting | description |
timescaledb.constraint_aware_append | on | Enable constraint-aware append scans |
timescaledb.disable_optimizations | off | Disable all timescale query opt imizations |
timescaledb.optimize_non_hypertables | off | Apply timescale query optimization to plain tables |
timescaledb.restoring | off | Install timescale in restoring mode |
timescaledb.disable_load | off | Disable the loading of the actual extension |
timescaledb.enable_ordered_append | on | Enable ordered append scans |
timescaledb.last_tuned | ㅤ | last tune run |
timescaledb.last_tuned_version | ㅤ | version of timescaledb-tune |
timescaledb.license_key | CommunityLicense | TimescaleDB license key |
timescaledb.max_background_workers | 8 | Maximum background worker processes allocated to TimescaleDB |
timescaledb.max_cached_chunks_per_hypertable | 100 | Maximum cached chunks |
timescaledb.max_open_chunks_per_insert | 167 | Maximum open chunks per insert |
timescaledb.telemetry_level | basic | Telemetry settings level |