---
title: remove_tiering_policy() | Tiger Data Docs
description: Remove the tiering policy from a hypertable or continuous aggregate
---

Remove the tiering policy from a hypertable or continuous aggregate. The underlying Tiger Cloud background job is deleted, so no further chunks are tiered automatically.

Chunks that the policy had already frozen and queued for upload but had not yet shipped to object storage are unfrozen and removed from the tiering queue. Chunks that have already been uploaded to object storage remain tiered; use [`untier_chunk`](/reference/tiger-cloud/data-tiering/untier_chunk/index.md) to bring them back.

## Samples

- **Remove the tiering policy from the `assets_candlestick_daily` hypertable**:

  ```
  SELECT remove_tiering_policy('assets_candlestick_daily');
  ```

- **Remove the tiering policy from a continuous aggregate, ignoring the call when no policy exists**:

  ```
  SELECT remove_tiering_policy('daily_summary', if_exists => true);
  ```

## Arguments

The syntax is:

```
SELECT remove_tiering_policy(
    hypertable = '<hypertable_or_cagg_name>',
    if_exists = true | false
);
```

| Name         | Type       | Default | Required | Description                                                                                  |
| ------------ | ---------- | ------- | -------- | -------------------------------------------------------------------------------------------- |
| `hypertable` | `REGCLASS` | -       | ✔        | Name of the hypertable or continuous aggregate the tiering policy is attached to.            |
| `if_exists`  | `BOOLEAN`  | `false` | -        | When `true`, emit a notice rather than an error if no tiering policy exists on the relation. |

## Returns

This function returns void.

## Errors

`remove_tiering_policy` raises an exception when:

- The supplied relation is neither a hypertable nor a continuous aggregate.
- No tiering policy exists on the relation and `if_exists` is `false`.