Skip to content
🚀 Agentic Postgres: The first database built for agents 🤖
TimescaleDB - Timeseries database for PostgreSQL Docs
  • tigerdata.com
  • Try for free
Get started
Try the key Tiger Data features
Start coding with Tiger Data
Create a Tiger Cloud service
About Tiger Data products
Tiger Data architecture for real-time analytics
Pricing plans and account management
Feature comparison
Use Tiger Data products
Hypertables
Hypercore
Continuous aggregates
Tutorials
Integrations
API Reference
Hypertables and chunks
Hypercore
Continuous aggregates
Data retention
add_retention_policy
remove_retention_policy
Jobs and automation
UUIDv7 functions
Hyperfunctions
Informational views
Service configuration
Administration Functions
API Reference Tag Overview
Tiger Cloud REST API
Glossary
Compression (Old API, replaced by Hypercore)
Distributed hypertables (Sunsetted v2.14.x)
Import and sync
Integrate AI with Tiger Data
Other deployment options
Find a docs page
TimescaleDB API referenceData retention

remove_retention_policy()

CommunityCommunity functions are available under Timescale Community Edition. Click to learn more.

Tiger Cloud: Performance, Scale, Enterprise, Free

Self-hosted products

MST

Remove a policy to drop chunks of a particular hypertable.

Samples

SELECT remove_retention_policy('conditions');

Removes the existing data retention policy for the conditions table.

Required arguments

NameTypeDescription
relationREGCLASSName of the hypertable or continuous aggregate from which to remove the policy

Optional arguments

NameTypeDescription
if_existsBOOLEANSet to true to avoid throwing an error if the policy does not exist. Defaults to false.

Keywords

data retentionpoliciesremove

Found an issue on this page?Report an issue or Edit this page in GitHub.

Previousadd_retention_policyNextJobs and automation

Related Content

remove_reorder_policy()
Remove a reorder policy from a hypertable
add_retention_policy()
Add a policy to drop older chunks
remove_columnstore_policy()
Remove a columnstore policy from a hypertable
remove_compression_policy()
Remove a compression policy from a hypertable
remove_continuous_aggregate_policy()
Remove a refresh policy from a continuous aggregate
Data retention
TimescaleDB API reference for data retention. Includes SQL functions for adding and removing data retention policies that run on a schedule that you define