Skip to content
Search ⌘K
Get started

Service configuration

Use the default PostgreSQL server configuration settings for your Tiger Cloud service, or customize them as needed

TimescaleDB uses the default PostgreSQL server configuration settings. You can optimize your service configuration using the following TimescaleDB and Grand Unified Configuration (GUC) parameters.

Samples

Section titled “Samples”

View current TimescaleDB settings

Section titled “View current TimescaleDB settings”

Check all TimescaleDB-specific configuration settings:

SELECT name, setting, unit, short_desc
FROM pg_settings
WHERE name LIKE 'timescaledb%'
ORDER BY name;

Enable chunkwise aggregation

Section titled “Enable chunkwise aggregation”

Enable query optimization for aggregations:

ALTER DATABASE your_database SET timescaledb.enable_chunkwise_aggregation = 'on';

Or set it for your current session:

SET timescaledb.enable_chunkwise_aggregation = on;

Enable vectorized aggregation

Section titled “Enable vectorized aggregation”

Enable vectorized optimizations for compressed chunks:

ALTER DATABASE your_database SET timescaledb.vectorized_aggregation = 'on';

Configure continuous aggregate refresh optimization

Section titled “Configure continuous aggregate refresh optimization”

Enable merge optimization for continuous aggregate refreshes:

SET timescaledb.enable_merge_on_cagg_refresh = on;

Disable telemetry

Section titled “Disable telemetry”

Turn off telemetry reporting:

ALTER SYSTEM SET timescaledb.telemetry_level = 'off';
SELECT pg_reload_conf();

Check TimescaleDB version and license

Section titled “Check TimescaleDB version and license”

View the current TimescaleDB version and license:

SELECT extname, extversion
FROM pg_extension
WHERE extname = 'timescaledb';


SHOW timescaledb.license;

Available configuration options

Section titled “Available configuration options”