Migrate PostgreSQL tables to hypertables

migrate-postgres-tables-to-hypertablesskillsetup L21,758
timescale/pg-aiguide
What it does

migrate or convert postgresql tables to hypertables

Best for

Planning and executing minimal-downtime migrations of large PostgreSQL tables to TimescaleDB.

Outputs
  • · result
  • · response
Requires
  • · PostgreSQL
  • · TimescaleDB
Preconditions
  • · ** Tables already identified as candidates (use find-hypertable-candidates first if needed)
  • · Requires PostgreSQL 15+ with TimescaleDB
Failure modes
  • · **Default:** Keep default of 7 days if unsure
  • · DO NOT modify the primary key/unique constraint without user permission.
Trust signals
  • · Comprehensive documentation with examples
  • · Code examples included
  • · Compatibility information provided