Difference between revisions of "TimescaleDB"
Jump to navigation
Jump to search
(→Errors) |
|||
| (12 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | [[wikipedia:TimescaleDB]] (Nov 2018) | + | [[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/ | * https://www.timescale.com/ | ||
* [[Michael J. Freedman]] | * [[Michael J. Freedman]] | ||
| + | * https://trends.google.com/trends/explore?date=all&q=TimescaleDB,InfluxDB | ||
== Installation == | == Installation == | ||
| Line 7: | Line 8: | ||
* <code>[[brew tap]] timescale/tap</code> | * <code>[[brew tap]] timescale/tap</code> | ||
* <code>[[brew install timescaledb]]</code> | * <code>[[brew install timescaledb]]</code> | ||
| + | * Status: <code>[[systemctl status postgresql@14-main]]</code> | ||
| + | * Configuration: <code>[[postgresql.conf]]</code> | ||
== Binaries == | == Binaries == | ||
| Line 12: | Line 15: | ||
* <code>[[timescaledb_move.sh]]</code> | * <code>[[timescaledb_move.sh]]</code> | ||
* <code>[[timescaledb-parallel-copy]]</code> | * <code>[[timescaledb-parallel-copy]]</code> | ||
| + | |||
| + | == Errors == | ||
| + | [[ERROR: could not access file]] "$libdir/timescaledb-2.10.3": [[No such file or directory]] | ||
| + | ERROR [[#58P01]] could not access file "$libdir/timescaledb-2.10.3": No such file or directory. Retrying... | ||
== Related == | == Related == | ||
* [[InfluxDB]] (2013) | * [[InfluxDB]] (2013) | ||
* [[Data partitioning]] | * [[Data partitioning]] | ||
| − | * [[Hypertable]]: [[create_hypertable]] | + | * [[Hypertable]]: <code>[[create_hypertable]]</code> |
| + | * <code>[[CREATE EXTENSION]] timescaledb;</code> | ||
* [[Timescale Cloud]] | * [[Timescale Cloud]] | ||
| − | |||
* [[TimescaleDB versions]] | * [[TimescaleDB versions]] | ||
| − | * [[Port]]: | + | * [[Port]]: [[5432]], [[7432]] |
| − | + | ||
* <code>[[SELECT * FROM timescaledb information.hypertables WHERE hypertable name = 'data']]</code> | * <code>[[SELECT * FROM timescaledb information.hypertables WHERE hypertable name = 'data']]</code> | ||
Latest revision as of 08:54, 1 June 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[edit]
- TimescaleDB installation
brew tap timescale/tapbrew install timescaledb- Status:
systemctl status postgresql@14-main - Configuration:
postgresql.conf
Binaries[edit]
Errors[edit]
ERROR: could not access file "$libdir/timescaledb-2.10.3": No such file or directory ERROR #58P01 could not access file "$libdir/timescaledb-2.10.3": No such file or directory. Retrying...
Related[edit]
- InfluxDB (2013)
- Data partitioning
- Hypertable:
create_hypertable CREATE EXTENSION timescaledb;- Timescale Cloud
- TimescaleDB versions
- Port: 5432, 7432
See also[edit]
Advertising:
