Difference between revisions of "TimescaleDB"
Jump to navigation
Jump to search
| Line 22: | Line 22: | ||
* <code>[[CREATE EXTENSION]] timescaledb;</code> | * <code>[[CREATE EXTENSION]] timescaledb;</code> | ||
* [[TimescaleDB versions]] | * [[TimescaleDB versions]] | ||
| − | * [[Port]]: 7432 | + | * [[Port]]: [[5432]], [[7432]] |
* <code>[[postgresql.conf]]</code> | * <code>[[postgresql.conf]]</code> | ||
* <code>[[SELECT * FROM timescaledb information.hypertables WHERE hypertable name = 'data']]</code> | * <code>[[SELECT * FROM timescaledb information.hypertables WHERE hypertable name = 'data']]</code> | ||
Revision as of 09:58, 3 March 2023
wikipedia:TimescaleDB (Nov 2018) is an open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.
- https://www.timescale.com/
- Michael J. Freedman
- https://trends.google.com/trends/explore?date=all&q=TimescaleDB,InfluxDB
Contents
Installation
- TimescaleDB installation
brew tap timescale/tapbrew install timescaledb- Status:
systemctl status postgresql@14-main
Binaries
Related
- InfluxDB (2013)
- Data partitioning
- Hypertable:
create_hypertable - Timescale Cloud
CREATE EXTENSION timescaledb;- TimescaleDB versions
- Port: 5432, 7432
postgresql.confSELECT * FROM timescaledb information.hypertables WHERE hypertable name = 'data'
See also
Advertising:
