• Yannis Roussos's avatar
    Add web_hook_logs partitioning migration · 11cf38bb
    Yannis Roussos authored
    - Create a new partitioned table web_hook_logs_part_0c5294f417
      with a nearly identical schema as web_hook_logs
    - Create all the monthly partitions that cover
      existing web_hook_logs data
    - Install trigger that keeps tables in sync
    - Add WebHookLogPartitioned model and register it for
      dynamic partition creation
    - Schedule background migration jobs to copy data from web_hook_logs
      to the partitioned table
    - Add explicit primary key definition to WebHookLog
      This will facilitate the smooth transition when we swap the tables
    11cf38bb
schema_spec.rb 11.5 KB