Hello, I am new to Timescale but it looks amazing! I am trying to enable Hypercore on a Hypertable so that I can turn on compression, but keep running into an error.
I am attempting to follow the commands found at ( Timescale Documentation | Hypercore ) and ( Timescale documentation )
I am running TimescaleDB 2.19.0 on PostgreSQL 17.4 on Ubuntu 24.04.2 LTS.
# SELECT create_hypertable('metrics', by_range('time', INTERVAL '1 day'));
create_hypertable
-------------------
(1,t)
(1 row)
# alter table metrics SET(timescaledb.enable_columnstore, timescaledb.orderby = 'time DESC', timescaledb.segmentby = 'grid_id');
ERROR: unrecognized parameter namespace "timescaledb"
I also tried without the “orderby”
# ALTER TABLE metrics SET (timescaledb.enable_columnstore = true, timescaledb.segmentby = 'grid_id');
ERROR: unrecognized parameter namespace "timescaledb"
I think Timescale is loaded/working properly, but with that error, I am not so sure!
# \dx
List of installed extensions
Name | Version | Schema | Description
---------------+---------+------------+---------------------------------------------------------------------------------------
cube | 1.5 | public | data type for multidimensional cubes
earthdistance | 1.2 | public | calculate great-circle distances on the surface of the Earth
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
timescaledb | 2.19.0 | public | Enables scalable inserts and complex queries for time-series data (Community Edition)
(4 rows)
# \dn
List of schemas
Name | Owner
--------------------------+-------------------
_timescaledb_cache | postgres
_timescaledb_catalog | postgres
_timescaledb_config | postgres
_timescaledb_debug | postgres
_timescaledb_functions | postgres
_timescaledb_internal | postgres
public | pg_database_owner
timescaledb_experimental | postgres
timescaledb_information | postgres
(9 rows)
Thank you for any insights on what to try next!