search

jenkins-infra / uplink

A simple telemetry service for Jenkins instances.
https://uplink.jenkins.io/
GNU Affero General Public License v3.0
1 stars 2 forks source link

Convert the events.payload column to JSONB to allow querying. #20

Closed rtyler closed 5 years ago

rtyler commented 5 years ago

We don't need this right now, but I imagine this is better to do before the data set grows any larger in the production database

rtyler commented 5 years ago

This migration will take some time in production, so I will need to run it out of band from the container booting up which also runs migrations

rtyler commented 5 years ago

I have run this migration in production, it took about 8 minutes and we locked the table causing some events to not come in