---
title: Service configuration | Tiger Data Docs
description: 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

### 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

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

Enable vectorized optimizations for compressed chunks:

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

### Configure continuous aggregate refresh optimization

Enable merge optimization for continuous aggregate refreshes:

```
SET timescaledb.enable_merge_on_cagg_refresh = on;
```

### Report continuous aggregate refresh statistics

Have every refresh report the batches it processed, the refresh window, and the rows it materialized and deleted. For your session, where the report arrives as a notice:

```
SET timescaledb.cagg_refresh_stats_level = 'summary';
```

```
NOTICE:  continuous aggregate refresh: processed 4 batch(es) of 4 in window [ 2021-05-01 00:00:00+00, 2021-06-01 00:00:00+00 ], materialized 31 row(s), deleted 0 row(s)
```

For the database, which also covers refresh policies, whose runs report to the server log:

```
ALTER DATABASE your_database SET timescaledb.cagg_refresh_stats_level = 'summary';
```

### Disable telemetry

Turn off telemetry reporting:

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

### Check TimescaleDB version and license

View the current TimescaleDB version and license:

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


SHOW timescaledb.license;
```

To interpret the license value and see which features each edition includes, see [Compare TimescaleDB editions](/docs/get-started/choose-your-path/timescaledb-editions#check-your-installed-edition/index.md).

## Available configuration options

- [TimescaleDB configuration and tuning](/docs/reference/timescaledb/configuration/tiger-postgres/index.md): configure the TimescaleDB settings related to policies, query planning and execution, and administration
- [Grand Unified Configuration (GUC) parameters](/docs/reference/timescaledb/configuration/gucs/index.md): optimize the behavior of TimescaleDB using Grand Unified Configuration (GUC) parameters