参考
[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 |
报错
CMake Error at CMakeLists.txt:294 (message)
使用例子测试
下载样本数据
导入结构
导入数据
每天同车超过2人的交易，平均计费多少？
某些查询的性能甚至超过20倍
用到timescaleDB内置的一些加速算法。每5分钟间隔为一个BUCKET，输出每个间隔产生了多少笔订单
每个城市的打车交易量
- Author:ayee
- URL:http://preview.tangly1024.com/article/3768d88b-b050-8037-8c87-c1042cd9cf83
- Copyright:All articles in this blog, except for special statements, adopt BY-NC-SA agreement. Please indicate the source!
Relate Posts
