> ## Documentation Index
> Fetch the complete documentation index at: https://mintlify-poc.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Service configuration

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

export const TIMESCALE_DB = 'TimescaleDB';

export const PG = 'Postgres';

export const SERVICE_SHORT = 'service';

export const SERVICE_LONG = 'Tiger Cloud service';

{TIMESCALE_DB} uses the default {PG} server configuration settings. You can optimize your {SERVICE_SHORT} configuration
using the following {TIMESCALE_DB} and Grand Unified Configuration (GUC) parameters.

## Samples

### View current TimescaleDB settings

Check all TimescaleDB-specific configuration settings:

```sql theme={"dark"}
SELECT name, setting, unit, short_desc
FROM pg_settings
WHERE name LIKE 'timescaledb%'
ORDER BY name;
```

### Enable chunkwise aggregation

Enable query optimization for aggregations:

```sql theme={"dark"}
ALTER DATABASE your_database SET timescaledb.enable_chunkwise_aggregation = 'on';
```

Or set it for your current session:

```sql theme={"dark"}
SET timescaledb.enable_chunkwise_aggregation = on;
```

### Enable vectorized aggregation

Enable vectorized optimizations for compressed chunks:

```sql theme={"dark"}
ALTER DATABASE your_database SET timescaledb.vectorized_aggregation = 'on';
```

### Configure continuous aggregate refresh optimization

Enable merge optimization for continuous aggregate refreshes:

```sql theme={"dark"}
SET timescaledb.enable_merge_on_cagg_refresh = on;
```

### Disable telemetry

Turn off telemetry reporting:

```sql theme={"dark"}
ALTER SYSTEM SET timescaledb.telemetry_level = 'off';
SELECT pg_reload_conf();
```

### Check TimescaleDB version and license

View the current TimescaleDB version and license:

```sql theme={"dark"}
SELECT extname, extversion
FROM pg_extension
WHERE extname = 'timescaledb';

SHOW timescaledb.license;
```

## Available configuration options

* [TimescaleDB configuration and tuning][tigerpostgres-config]: configure the TimescaleDB settings related to policies,
  query planning and execution, distributed hypertables, and administration
* [Grand Unified Configuration (GUC) parameters][gucs]: optimize the behavior of TimescaleDB using Grand Unified
  Configuration (GUC) parameters

[gucs]: /api-reference/timescaledb/configuration/gucs

[tigerpostgres-config]: /api-reference/timescaledb/configuration/tiger-postgres